**Re: Adding with percentages and more**

Hmmm... having worked with financials for years, I too have tried to create a macro that would do something like you want. (I bet there's a macro whiz that can, it just isn't me!) If not, you'll have to manually edit every cell. So what I do is put the formula in another column, since the problem when recording said macro is that the value in the cell you're editing becomes part of the macro!

If you have 25 in cell B3, for instance, just put this in cell C3 and drag 'er down:

=B3*0.25+100*0.15. You can take it a step further, and have the variables reside in their own cells so that when you change the variables you only need to make the change in that particular cell and it'll hit all the cells. Maybe put the 25% in cell A1, the 100 in B1, and the 15% in C1. Now make your formula in C3 this: =B3*$A$1+$B$1*$C$1. Now, when you drag the formula down, your original price cell will always change to reflect the correct one you want to apply your formula to (B3 will become B4, B5, etc.) and the other references will remain as they are. The $ indicates an "absolute reference" that is, indicating that you always want to use the numbers in cells A1, B1, and C1 to change your other numbers (B3, B4, and so on) to suit.

HTH...

Regards,

XLXRider

OK, just saw your last post... make the formula parenthesized like this:=(B3*1.25+100)*1.15