combining IF and AND
 

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

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



"Dahlman" wrote in message
...
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

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


--
Regards,

Peo Sjoblom


"Dahlman" wrote in message
...
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

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

"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

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

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

"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

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