ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Excel (https://www.excelbanter.com/excel-discussion-misc-queries/187122-excel.html)

Angee[_2_]

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

Pete_UK

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



JE McGimpsey

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