On 24/10/2008 21:10, Dave Barton wrote:
-------- Original Message --------
From: Walter Hildebrandt <[EMAIL PROTECTED]>
Date: Fri, 24 Oct 2008 13:43:53 -0600
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.
Hi Walter,
For C1 I would suggest the following formula =IF(A1>B1,A1-B1,0)
Dave
I haven't installed v3 yet; have they changed the syntax of formulae to
use commas instead of semicolons between arguments?
In OOo 2.x it would have been =IF(A1>B1;A1-B1;0)
--
Harold Fuchs
London, England
Please reply *only* to [email protected]
