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.
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.