Formula Help

  • Thread starter Thread starter philmikips
  • Start date Start date
P

philmikips

I am trying to increase the prices on a spreadsheet. For example, colum
D7 has a price of $8122.77, E7 is $5122.46, F7 is $6544.54 etc. etc.
am trying to increase prices 3%. What formula should I use? Thanks i
advance for any help
 
Is there a way I can highlight and do all of them at the same time? I'v
tried =d7*1.03 and others but none seem to work
 
Not sure what you want. Do you want a formula or do you want to jus
change the values so that they are 3% higher than their curren
values?

If the latter option is what you want AND the cells containing you
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 Past
Special
Click on Multiply
Click O
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Constant Data to be used for different possibilities 3
Formula's to count 3
Right Filling A Formula Whilst Keeping A Static Column 4
If condition to find Target 2
Joining Two formulas with the Help of AND / OR / IF Functions to getthe desired result 1
Countif Cell multiple arguments 2
counting multiple criteria using SUMPRODUCT and getting #VALUE err 1
More than one "if" in a cell 9

Back
Top