Walter Hildebrandt wrote the following on 10/24/2008 1:43 PM:
Using a 3.0 spreadsheet, is it possible to put a "limit" into a formula:
If $400 was in cell A1 and $416.67 is in call B1 and the formula in C1
was =A1-B1, the results in C1 would be -$16.67. Can the formula be
modified so that any time cell C1 produced a negative number, the
entry in C1 would be zero or no number would be added into cell C1.
Column C will have entries on other rows. Columns C will be total
up. Only positive numbers in column C are to be included in the total
of column C.
How about using this formula in cell C1:
=IF(A1-B1< 0,0,A1-B1)
If A1-B1 results in a negative number, this would place a 0 in cell C1.
Otherwise it would place the results of A1-B1 in cell C1.
Regards,
Jack
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
