add same multiplier to unique formulas

  • Thread starter Thread starter beachez
  • Start date Start date
B

beachez

Hi,
I am trying to figure out how to add a multiplier to many formulas tha
each contain a unique hard number. The scenario:
Column a is the quantity of items, and column c is multiplying colum
a*the actual price of that item whose name is listed in column b. Th
formula in column c is currently a3*99, which shows a value of $99 fo
a 1 entered in column a. We want to do a price increase to our variou
line items without having to manually go type in a3*104, for example t
do a 5% price increase. Can anyone help??? I would like to be able t
tell it to multiply all the cells I highlight by 5% - maybe get it t
insert some new parameters so it looks like (a3*99)*1.05, does anyon
know how to do this???
Thanks!
Nathan :
 
Nathan,

Enter 1.05 into a blank cell, copy that cell, then select your cells with
formulas and right-click, choose Paste Special... then Multiply and OK.

Excel will change your formula
=A3*99
to
=(A3*99)*1.05

HTH,
Bernie
MS Excel MVP
 
Nathan

Enter 1.05 in an empty cell.

Copy this and then select your range of numbers.

Paste Special>Multiply>OK>Esc.

Clear the cell with the 1.05

If you set up your formulas from the start with a multiplier cell reference,
all you have to do is change the multiplier number.

e.g. =(A3*99)*G4 where G4 contains 1.05 or whatever.

Gord Dibben Excel MVP
 
Back
Top