Follow this topic

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?

0

6

Resolved: Why don't we have an exercise sheet for this video?

1

6

Hi. Are you using some key combination to put the $ sign in your formula?

Alejandro Hasselmeyer

2

4

Resolved: Excel extending a formula down a column without me asking it to. Causes Spill error

0

4

Resolved: Column width increasing instead of decreasing?

1

4

No error for last formula

Manish Rochwani

0

4

percent variance formula showing error