how to add 130% to a selected range of numbers ?

  • Thread starter Thread starter MATHIMATICALLY IMPAIRED
  • Start date Start date
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.





MATHIMATICALLY IMPAIRED <MATHIMATICALLY
 
In an un-used cell enter 2.3 and copy this cell.

Select the other cells you wish to modify and:

Edit > PasteSpecial > multiply
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel VBA - Problem with Closing Print Preview 0
Add New Worksheet in new workbook 4
Excel VBA to move cursor from 1 cell to another, once original cell is filled with data. 3
Access Dcount (multiple criteria) 3
Need to count a set of numbers in a range 4
Adding minutes to hours/minutes 4
Can Vba workout if a selection is part of a group? 0
Counting text which meets a criteria 2

Back
Top