![]() |
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 |
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 |
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 |
All times are GMT +1. The time now is 08:37 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com