Excel

A

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
 
P

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
 
J

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