How do I calculate a specific formula for price increases?

  • Thread starter Thread starter Charlie
  • Start date Start date
C

Charlie

I need to update a spreadsheet, increasing all the values in column A as
follows:

=sum

-7.5%
+20
+5%

I've got so far : =A1*0.925+20 and this calculates the correct total to
this point

but when I try to add 5% to the end of the formula the sum fails

Also, when the new formula is calculated, how do I add it in so that it
calculates the correct sum for the whole spreadsheet

There are around 500 entries, i.e. from A1 - A500 and all these values need
to be subjected to the above calculation
 
Charlie,

=(A1*0.925+20)*1.05

or use cell references:

=(A1*(1+C2)+C3)*(1+C4)
with your numbers as below in C2 to C4.


HTH,
Bernie
MS Excel MVP
 
Gary''s Student said:
=1.05*(A1*0.925+20)
Click to expand...


THANKS GARY - THATS SO SIMPLE WHEN SOMEBODY ELSE TELLS YOU THE ANSWER.

Knew I should have paid more attention during Equations
 
Back
Top