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)”. 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!

Resources