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.

 

[Marq]

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","")

I do not see an E29 reference in your formula

 

[Marq]

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","")

I tried this but didnt work either:

=IF(AND(OR($B$6="Cryogel",$B$6="Pyrogel",$B$6="Mineral Wool"),OR(E29="X"),OR($B$8=".016 SS",$B$8=".020 SS",$B$8=".024 SS")),"X","")

 

[Candyman8019]

Sorry about that Marq. Give this a go:
=IF(AND($E$29="X",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","")

 

[Marq]

Sorry about that Marq. Give this a go:
=IF(AND($E$29="X",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","")

Weird..still isnt working...the SS options arent putting the "x" in E34.

I put an X in E29....then choose one of the three SS options in B8 drop down, no X populates E34 when one should.

Also, when I choose one of the three options (cryogel, pyrogel, mineral wool) in B6 (which those 3 options do not require to have an X in E29) and choose one of the SS choices in B8, no X appears in E34.

 

[Candyman8019]

I think I see what you're saying now. Try this one:
=IF(OR(AND($E$29="X",OR($B$8=".016 SS",$B$8=".020 SS",$B$8=".024 SS")),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","")

 

[Marq]

I think I see what you're saying now. Try this one:
=IF(OR(AND($E$29="X",OR($B$8=".016 SS",$B$8=".020 SS",$B$8=".024 SS")),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","")

That works!!!!!! Thanks for your patience!!!!

Thank you!