Subtraction of 2 numbers/cells
Try one of two:
=(A1-B1)*(A1B1)
=(A1-B1)*(A1=B1)
Micky
"Cipri" wrote:
Could anyone please help me with this situation (in Excel 2003):
I have 2 cells
A1 = 0 and B1 = 10
In cell C1 i put this formula C1=A1-B1 . Now the answer will be C1=
-10 but my question is:
Is there a formula to calculate in C1 the result if the answer is positive
and if the answer is negative to put 0?
Thank you in advance.
|