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]
