combining IF and AND

D

Dahlman

I want my cell to the following:

If cell E7 does not equal zero and K7 does equal zero then in J7 display
"100.00%"

But if E7 does equal zero the display an emply cell.

But if E7 doesn't equal zero and neither does K7 then do the formula
(1-(K7/E7)).

End

I just can't figure out how to do this...I can enter my statements into an
AND function but it only display true or false. Why can't I decide what it
displays?

Please help if you can. Thanks in advance

Travis Dahlman
 
N

N Harkawat

=IF(E7=0,"",IF(AND(E7<>0,K7=0),TEXT(1,"0.00%"),IF(AND(E7<>0,K7<>0),(1-(K7/E7)))))
 
M

Mexage

=If(AND(E7<>0,K7<>0),100%,SOMETHING_ELSE)

If it helps, vote for it with the buttons below.
 
Top