How do I get rid of the FALSE result in this IF formula

[Marq]

using 365

I have an IF formula that does work : =IF($E$29="X",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))))

If the criteria isn't met, I get a FALSE result.....how do I make it show as blank if the criteria isn't met?

I tried =IF($E$29="X","",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X","")))) but it did not work.

 

[Joe4]

Your second formula did not return FALSE for me:

=IF($E$29="X","",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))))

 

[Candyman8019]

This should also work:
=IF($E$29="X",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))),"")

 

[Marq]

Your second formula did not return FALSE for me:

=IF($E$29="X","",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))))

But it doesn't give me an X if I have I choose .016 SS or .020SS or .024SS in B8 drop down. It shows it blank....I need an X there.

 

[Candyman8019]

The original two formulas do different things...the first one MUST have E29 as X in order to further evaluate B8. The second one will result in "" if there is an X in E29. Unless I'm reading that wrong...

 

[Marq]

This should also work:
=IF($E$29="X",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))),"")

Yep..works..thanks...seems I had my "" in the wrong spot.

 

[Marq]

Now that this is working....I realized im needing more criteria

Here is the working formula from Candyman: =IF($E$29="X",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))),"")

After I put the formula in and its working it made me realize I need to add criteria from a another drop down.

it will be an either/or type scenario

so maybe two separate formulas in one cell???

To say if B6 drop down equals Cryogel...or equals Pyrogel..or equals Mineral wool...then give me an X in this cell...…...OR candymans working formula.

 

[Candyman8019]

Give this a try:
=IF(OR($B$6="Cryogel",$B$6="Pyrogel",$B$6="Mineral Wool"),"X",IF($E$29="X",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))),""))
If B6 contains one of the 3 values then X; else if E29=X and B8 is one of the 3 specified values then X else blank.

 

[Marq]

Give this a try:
=IF(OR($B$6="Cryogel",$B$6="Pyrogel",$B$6="Mineral Wool"),"X",IF($E$29="X",IF($B$8=".016 SS","X",IF($B$8=".020 SS","X",IF($B$8=".024 SS","X",""))),""))
If B6 contains one of the 3 values then X; else if E29=X and B8 is one of the 3 specified values then X else blank.

Does not work. Its working halfway sorta. Here is whats happening when I load your formula into E34: I chose Cryogel in B6 dropdown and E34 automatically gets an X...it shouldn't get an X unless I also choose one of the SS options in B8. So basically with your formula E34 is populating with an X prematurely.

The cell the formula is in E34.....E34 should get an X only if:

E29 is an X and B8 drop down choice is 016 ss or .020 ss or .024 ss
B6 drop down is cryogel and B8 drop down choice is .016 ss or .020 ss or .024 ss
B6 drop down is pyrogel and B8 drop down choice is .016 ss or .020 ss or .024 ss
B6 drop down is Mineral wool and B8 drop down choice is .016 ss or .020 ss or .024 ss

otherwise leave it blank.

 

[Candyman8019]

Yep, that's a different scenario...give this a go:
=IF(AND(OR($B$6="Cryogel",$B$6="Pyrogel",$B$6="Mineral Wool"),OR($B$8=".016 SS",$B$8=".020 SS",$B$8=".024 SS")),"X","")