Forum Discussion
if and ifs
I have a Microsoft 365 user subscription. I want to use the IF formuls for multiple conditions. It works well for one condition such as: =IF(B14=0," ",(B14/B$8)-1) When I need to add a few mo...
I'm sorry, but what's the difference between
=IFS(B18=0,"",B$8=0,"",C$8=0,"",TRUE,(B18/B$8))
and
=IF(OR(B18=0,B$8=0,C$8=0),"",(B18/B$8))they return exactly the same result, did I miss something?
One more could be
=IFERROR(B18/B18*C$8/C$8*B18/B$8,"")