Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 1
Default how to add 130% to a selected range of numbers ?

I AM TRYING TO ADD PERCENTAGES TO PROPOSALS
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default how to add 130% to a selected range of numbers ?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 11,058
Default how to add 130% to a selected range of numbers ?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,389
Default how to add 130% to a selected range of numbers ?

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   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 4,624
Default how to add 130% to a selected range of numbers ?

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
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


Similar Threads
Thread Thread Starter Forum Replies Last Post
Setting var to selected Range El Bee Excel Discussion (Misc queries) 2 January 18th 08 09:31 PM
Appearance of a selected range d_mack Excel Discussion (Misc queries) 10 October 5th 07 12:31 AM
two columns range of numbers need to list all numbers in the range arsovat New Users to Excel 2 October 30th 06 08:21 PM
How to generate a list of randomly selected numbers within a range Bob Excel Worksheet Functions 2 November 7th 05 06:09 PM
delete every nth row in selected range cwinters Excel Discussion (Misc queries) 1 July 6th 05 08:17 PM


All times are GMT +1. The time now is 09:27 AM.

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"