#1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default Excel

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
--
Angee J
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 8,856
Default Excel

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

On May 12, 5:47*pm, Angee wrote:
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
--
Angee J


  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default Excel

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.






In article ,
Angee wrote:

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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 03:06 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"