G
Guest
I am trying to write a formula that considers multiple variables. I have
tried the following:
=IF(OR(B21>0.01,B21<=0.99),0.3,0.35)
and
=IF(AND(B21>0.01,B21<=0.99),0.3,0.35)
These work in themselves but I am trying to get it to also consider if the
relevant cell b21=0.
I need ithe formula to accept that IF b21>.01 and b21<=.99, it will display
..30, if it is above .01-.99 it displays .35 UNLESS the value of b21=0 then I
need it to display 0.
Help in this would be greatly appreciated.
tried the following:
=IF(OR(B21>0.01,B21<=0.99),0.3,0.35)
and
=IF(AND(B21>0.01,B21<=0.99),0.3,0.35)
These work in themselves but I am trying to get it to also consider if the
relevant cell b21=0.
I need ithe formula to accept that IF b21>.01 and b21<=.99, it will display
..30, if it is above .01-.99 it displays .35 UNLESS the value of b21=0 then I
need it to display 0.
Help in this would be greatly appreciated.