Formula Help
 

I am trying to increase the prices on a spreadsheet. For example, column
D7 has a price of $8122.77, E7 is $5122.46, F7 is $6544.54 etc. etc. I
am trying to increase prices 3%. What formula should I use? Thanks in
advance for any help.


--
philmikips
------------------------------------------------------------------------
philmikips's Profile: http://www.excelforum.com/member.php...o&userid=28633
View this thread: http://www.excelforum.com/showthread...hreadid=482964

Formula Help
 

Multiply each by 1.03


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=482964

Formula Help
 

Is there a way I can highlight and do all of them at the same time? I've
tried =d7*1.03 and others but none seem to work.


--
philmikips
------------------------------------------------------------------------
philmikips's Profile: http://www.excelforum.com/member.php...o&userid=28633
View this thread: http://www.excelforum.com/showthread...hreadid=482964

Formula Help
 

Not sure what you want. Do you want a formula or do you want to just
change the values so that they are 3% higher than their current
values?

If the latter option is what you want AND the cells containing your
values do not contain formulas do this:

In an empty cell anywhere on the sheet type in 1.03
Now copy that cell
Now highlight all the cells you want to make 3% higher
Right click on any of those highlighted cells and click on Paste
Special
Click on Multiply
Click OK


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=482964

Formula Help
 

Excellent! Thanks for your help.


--
philmikips
------------------------------------------------------------------------
philmikips's Profile: http://www.excelforum.com/member.php...o&userid=28633
View this thread: http://www.excelforum.com/showthread...hreadid=482964

Formula Help
 

You're welcome.


--
Cutter
------------------------------------------------------------------------
Cutter's Profile: http://www.excelforum.com/member.php...fo&userid=9848
View this thread: http://www.excelforum.com/showthread...hreadid=482964