I would like to increase my budget figures by a percentage

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

Guest

It is buget time and we need to increase the 2004 figures by 2% for 2005 is
there a formula that can do this in one command
 
enter 102% in a separate cell
Copy that cell
Select all the cells to increase
Goto Edit>PasteSpecial and select the Multiply button in the Operation
section
OK out

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
One easy way is to put 1.02 in a blank cell>copy that cell>select the cells
to change>edit>paste special>multiply
 
Dunno if this will help, but you could put the number 1.02 in a spare cell,
then select that cell, copy it to the clipboard, then select all of the
cells to be incremented and from the menu bar select
Edit/PasteSpecial
and select the "Multiply" operation before clicking OK to paste.
 
You must log in or register to reply here.

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

Increasing all values in spreadsheet by same percentage. 1
How do I increase a budget amount based on a 40% redemption 17
percentages 3
Change all of the cells in a row(s) by a percentage 4
increase an entire spreadsheet by a percentage 2
Increase whole column by same percentage 3
calculating percentage 3
Percentage Increase 13

Back
Top