Formula Question for Excel
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
On Sep 19, 3:18 pm, Formula applied to whole spreadsheet? <Formula
applied to whole wrote:
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.
|