-------- 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 --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
