Forum Discussion

MaddieLB's avatar
MaddieLB
Copper Contributor
Feb 26, 2020

Excel Help - Stacking IF Formulas

Hello! So I’m fairly new to using formulas in excel, and my work place has an inefficient system while trying to use excel for data review, so we use a lot of “IF(something=something, Pass, Fail)”. T...
excel
Formulas and Functions
PReagan's avatar
PReagan
Bronze Contributor
Feb 26, 2020

Hello MaddieLB,

 

Stacking two IF() functions looks like:

=IF(logical_test, [value_if_true], IF(logical_test, [value_if_true], [value_if_false]))

 To continue stacking, simply replace [value_if_false] with new IF() function.

Resources