Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I AM TRYING TO ADD PERCENTAGES TO PROPOSALS
|
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're also "SHOUTING" by using all caps...
One way: Enter 1.3 in an empty cell. Copy the cell. Select the cells you want to apply the increase to. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click OK. In article , MATHIMATICALLY IMPAIRED <MATHIMATICALLY wrote: I AM TRYING TO ADD PERCENTAGES TO PROPOSALS |
#3
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
In an un-used cell enter 2.3 and copy this cell.
Select the other cells you wish to modify and: Edit PasteSpecial multiply -- Gary''s Student - gsnu200826 "MATHIMATICALLY IMPAIRED" wrote: I AM TRYING TO ADD PERCENTAGES TO PROPOSALS |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I suspect this is the solution the OP is looking for, but, for the record,
multiplying by 1.3 will add 30% to a number. If the OP really wants to add 130%, use 2.3 instead. Regards, Fred "JE McGimpsey" wrote in message ... You're also "SHOUTING" by using all caps... One way: Enter 1.3 in an empty cell. Copy the cell. Select the cells you want to apply the increase to. Choose Edit/Paste Special, selecting the Values and Multiply radio buttons. Click OK. In article , MATHIMATICALLY IMPAIRED <MATHIMATICALLY wrote: I AM TRYING TO ADD PERCENTAGES TO PROPOSALS |
#5
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
You're exactly right. Thanks for the amplification.
In article , "Fred Smith" wrote: I suspect this is the solution the OP is looking for, but, for the record, multiplying by 1.3 will add 30% to a number. If the OP really wants to add 130%, use 2.3 instead |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Setting var to selected Range | Excel Discussion (Misc queries) | |||
Appearance of a selected range | Excel Discussion (Misc queries) | |||
two columns range of numbers need to list all numbers in the range | New Users to Excel | |||
How to generate a list of randomly selected numbers within a range | Excel Worksheet Functions | |||
delete every nth row in selected range | Excel Discussion (Misc queries) |