| Home |
| Search |
| Today's Posts |
|
|
|
#1
|
|||
|
|||
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 |
|
#2
|
|||
|
|||
|
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 |
|
#3
|
|||
|
|||
|
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 |
|
#4
|
|||
|
|||
|
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 |
|
#5
|
|||
|
|||
|
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 |
|
#6
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| IF formula? | Excel Worksheet Functions | |||
| writing a formula for a colored value | New Users to Excel | |||
| referencing named formula using INDIRECT function | Excel Worksheet Functions | |||
| Simplify formula | Excel Worksheet Functions | |||
| Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hybrid Mode
