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]
