Forum Discussion
MaddieLB
Feb 26, 2020Copper Contributor
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!
2 Replies
Sort By
- ChrisMendozaIron Contributor