Brian Barker wrote:
At 13:43 24/10/2008 -0600, Walter Hildebrandt wrote:
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.
The MAX() function returns the largest of its arguments. So one easy
way to do this is to use =MAX(A1-B1;0).
Columns C will be total up. Only positive numbers in column C are to
be included in the total of column C.
If the only value you need is this sum of the positive differences,
another way to obtain this would be to put just the simple differences
in the column (using =A1-B1, as you suggest) and then sum them with
=SUMIF(C1:C99;">0") instead of =SUM(C1:C99).
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
I tried the SUMIF formula . Err: 508 comes up with the , before the >
Err: 510 comes up with the ; before the >
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
