add a percentage to all numbers in a field

[des-sa]

please help.
is it possible to add a certain percentage to all numbers in, say, cell
A2..D10 with a single entry?
thanks

 

[muddan madhu]

Assumed you want to add 5 % to all the number,

In cell E1 put 1.05 and copy it

select the range A210 Go to edit | paste special | paste:values |
operation : multiply | ok

 

[Max]

is it possible to add a certain percentage to all numbers in, say, cell
A2..D10 with a single entry?

Suppose you want to increase it by 20%
Enter in an empty cell: 1.2
Copy that cell
Then select the range A210,
Right-click > paste special > Check Multiply > OK. Done

(If you want to decrease it by 10%, enter in the empty cell: 0.9)

High-five this response, click the YES button below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:23,000 Files:370 Subscribers:66
xdemechanik
---