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

"Dahlman" wrote:

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