combining IF and AND

[Guest]

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 Harkawat]

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

 

[Peo Sjoblom]

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

 

[Guest]

=IF(e7=0,"",IF(k7=0,100%,1-k7/e7))

 

[Guest]

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

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

 

[Guest]

Try this with an IF statement
=-IF(AND(E7<>0,K7=0),1*-1,(1-(K7/E7)))
Pat