Keith N. McKenna wrote:
Walter Hildebrandt wrote:
In Calc I am using the following formula in cell C1
=A1-B1)/B1
Is there some way to get an empty C1 cell when there is a negative
number in
either A1 or B1?
Walter;
Put this if statement into cell C1. =IF(A1-B1 < 0;0;A1-B1) which
says If the difference of A1-B1 is less than 0; C1 = zero; else C1 =
A1-B1
Hope this helps
Keith
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
Walter:
Assuming you meant:
=(A1-B1)/B1
I think you want
=IF(OR(A1<0; B1<0; B1=0);"";(A1-B1)/B1)
in C1. This prevents a divide by zero error.
-Bob
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
