mistux Site Admin
Joined: 25 Jun 2004 Posts: 1042 Location: South Bend, Indiana USA
|
Posted: Thu Jun 19, 2008 10:25 am Post subject: Add Value to a Range of Cells |
|
|
Q: I want to add 50% to each number in my spreadsheet, how do I do that?
A: In an empty cell put your value, in this case 1.5, then copy it and then select your range of cells that you want to increase, then select Edit (or right click) and select Past Special then Values (could also be formulas) and then select Multiply and click OK and there you have it. |
|