Excel Help - Stacking IF Formulas

[MaddieLB]

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)”. These formulas work great, but I wanted to see if there’s a way to stack these, such as if all the the rows in a certain column come up as Pass, then also show Pass. Unfortunately if I try to work it as just a normal IF function, I get a name error. Does anyone know of a way to stack IF functions?

Edit: Both of these worked beautifully and got me on track for other edits for the spreadsheet, thank you guys so much!

[#2]

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.

[#3]

@MaddieLB -

I would probably do something like the attached: