Formula Question for Excel

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I work for a boat dealership and I am making spreadsheets for pricing. I
have our net figures entered on multiple sheets and now I need to mark up
those prices and produce new spreadsheets that reflect retail pricing for our
sales staff. Is there a way to insert the same formula throughout the whole
page and mark each cell up accordingly? I am trying to avoid having to go to
each cell and type in our mark up equation. Any help is appreciated! Thanks
in advance.
 
Let's say that your mark-up is 15%. Select an empty cell somewhere and
enter 1.15 in that cell. Select the cell again and click <copy>, then
highlight all the cells that you want this mark-up to apply to and
Edit | Paste Special | Multiply (check) | OK then <Esc>. This will
increase all the highlighted cells by 15%, and you can remove the 1.15
from the original cell. Repeat for the other sheets.

Hope this helps.

Pete
 
It all depends on how your equations look. For example, say you are selling
flooring and the price per square foot installed is $6.99 and this value
appears all over the place in many separate cells. Now you want to increase
this by 5% to $7.34.

Edit > Replace
6.99 in the Find what box
7.34 in the Replace with box
Replace All

Every occurance of 6.99 will be replaced with 7.34.

If there are many different prices, but they are all in a single column
table, then put 1.05 in an un-used cell. select this cell and copy it. Then
select the the table of values and paste/special/mulitply. This will update
all the values in the table by 5%.

If there are lots of prices scattered all over the place, you are in trouble.
 
Back
Top