Excel Help - Stacking IF Formulas

%3CLINGO-SUB%20id%3D%22lingo-sub-1197031%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20-%20Stacking%20IF%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1197031%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568929%22%20target%3D%22_blank%22%3E%40MaddieLB%3C%2FA%3E%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EStacking%20two%20IF()%20functions%20looks%20like%3A%3C%2FP%3E%3CPRE%3E%3DIF(logical_test%2C%20%5Bvalue_if_true%5D%2C%20IF(logical_test%2C%20%5Bvalue_if_true%5D%2C%20%5Bvalue_if_false%5D))%3C%2FPRE%3E%3CP%3E%26nbsp%3BTo%20continue%20stacking%2C%20simply%20replace%20%5Bvalue_if_false%5D%20with%20new%20IF()%20function.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1197042%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20Help%20-%20Stacking%20IF%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1197042%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F568929%22%20target%3D%22_blank%22%3E%40MaddieLB%3C%2FA%3E%26nbsp%3B-%3C%2FP%3E%3CP%3EI%20would%20probably%20do%20something%20like%20the%20attached%3A%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F173696i12D20FDA1C9F2619%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1196970%22%20slang%3D%22en-US%22%3EExcel%20Help%20-%20Stacking%20IF%20Formulas%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1196970%22%20slang%3D%22en-US%22%3E%3CP%3EHello!%20So%20I%E2%80%99m%20fairly%20new%20to%20using%20formulas%20in%20excel%2C%20and%20my%20work%20place%20has%20an%20inefficient%20system%20while%20trying%20to%20use%20excel%20for%20data%20review%2C%20so%20we%20use%20a%20lot%20of%20%E2%80%9CIF(something%3Dsomething%2C%20Pass%2C%20Fail)%E2%80%9D.%20These%20formulas%20work%20great%2C%20but%20I%20wanted%20to%20see%20if%20there%E2%80%99s%20a%20way%20to%20stack%20these%2C%20such%20as%20if%20all%20the%20the%20rows%20in%20a%20certain%20column%20come%20up%20as%20Pass%2C%20then%20also%20show%20Pass.%20Unfortunately%20if%20I%20try%20to%20work%20it%20as%20just%20a%20normal%20IF%20function%2C%20I%20get%20a%20name%20error.%20Does%20anyone%20know%20of%20a%20way%20to%20stack%20IF%20functions%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EEdit%3A%20Both%20of%20these%20worked%20beautifully%20and%20got%20me%20on%20track%20for%20other%20edits%20for%20the%20spreadsheet%2C%20thank%20you%20guys%20so%20much!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1196970%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
Occasional Visitor

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
Highlighted

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.

Highlighted

@MaddieLB -

I would probably do something like the attached:image.png