Home |
Search |
Today's Posts |
|
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|