Excel

[Angee]

I need help with percents. I have several 100 cells that I need to add 10.5%
to and I can't figure out a formula. The 10.5% needs to be added to the
actual cell. Please help, anyone.. thx

 

[Pete_UK]

In a blank cell enter 1.105 and then <copy> that value. Highlight the
cells that you want to increase the value of, then click on Edit |
Paste Special | Values (check) | Multiply (check) | OK then <Esc>.

All values will now have been increased by 10.5%.

Hope this helps.

Pete

 

[JE McGimpsey]

One way:

Enter

= 1 + 10.5%

in a blank cell. Copy the cell. Select your cells that need to be
increased. Choose Edit/Paste Special, selecting the Values and Multiply
radio buttons. Click OK.