Harold Fuchs wrote the following on 10/24/2008 2:53 PM:
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)
My mistake! Of course I should have used semi-colons instead of commas
in the formula. I was actually working in Excel instead of Calc when I
sent my first answer.
Jack
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
