I would like to increase my budget figures by a percentage

W

Wendy

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
 
B

Bob Phillips

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)
 
D

Don Guillett

One easy way is to put 1.02 in a blank cell>copy that cell>select the cells
to change>edit>paste special>multiply
 
J

Jack Sheet

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.
 
Top