Lucia Indah Pramanti
Last answered:

07 Feb 2024

 Posted on:

01 Feb 2024
0

Resolved: Formula for y.o.y variations. Why IF instead of IFS?

in Introduction to Excel / Calculating Growth Rates in Excel

Hi, I see the IF formula you've provided is a nested if formula. Can you explain to me why didn't you use IFS function?

1 answers ( 1 marked as helpful)
Ned Krastev
Instructor
Posted on:

07 Feb 2024
1

Hey Lucia,

There are many different ways to write a formula. I belive that the IFS function didn't exist when I first wrote this formula:)

Best,

Ned

Helpful answer

Submit an answer

related questions

Mario Contreras
1
12
Why are we using SUMIF to transfer data instead of using VLOOKUP?
Panagiotis Blatsas
0
12
Index and Match exercise tried the exact formula yet all results are N/A?
Tural Mammadov
0
6
Resolved: Why don't we have an exercise sheet for this video?
Sali Sali
1
6
Hi. Are you using some key combination to put the $ sign in your formula?
Donald Trenholm
0
4
Resolved: error message "There's a problem with this formula"
Asmaa Abdulhamid
0
4
how to show the value in parentheses while it is assigned with a minus in the row formula
Donald Trenholm
0
4
error with formula
Dylan Ritter
0
4
Resolved: Column width increasing instead of decreasing?