Hi!

To do this with formulas would require an additional column and a separate
sum formula.

In J15 enter this formula:

=IF(I53<=2000,I15*1.1,I15)

Copy down to I43.

Put another Sum formula in J53:

=SUM(J15:J43)

If you're using R1C1 references, temporarily switch to back to A1 style,
enter the new formulas then switch back to R1C1.

Biff

"arrow" wrote in message
oups.com...
Hello... I'm new to using Excel. I have a spreadsheet that I'm trying
to find a formula for. I suppose I should mention that I am using
Excel 2000 and have the R1C1 reference enabled.

What I have is a column, R15C9:R43C9 (I believe this is how you'd
represent that, Row 15 through 43 in column 9). These columns are
autocalulated into the cell R53C9. I want a formula that will add 10%
to all the cells in the R15C9:R43C9 range if the result in R53C9 is
equal to or less then 2000.
From what I've read this can probably be accomplished using the IF
command, but I am not familiar enough with Excel to figure out the
formula using the help files.

For instance: if the original numbers for column nine we

500
500
500
400
------

1900

Then I want a formula that will add 10% to each of the cells in the
range, thus creating:

550
550
550
440
------

2090

Thanks.