Excel

  • Thread starter Thread starter Guest
  • Start date Start date
Copy the number 1.1 (or equivalently 110% from another cell and
Edit|Paste Special|Multiply

Jerry
 
To show the increase in another cell:

A1: 10
B1: =(1 + 10%) * A1 ===> 11

or a little more simply:

B1: =1.1*A1

To increase the value in-place:

Enter 1.1 in a blank cell. Copy the cell. Select the cell(s) to
increase by 10%. Choose Edit/Paste Special, selecting the Multiply and
Add radio buttons. Click OK.
 
Hi Anna!

In an empty cell enter 1.1
Now, copy that cell
Select the cell you want to increase by 10%
Then do: Paste special
Click: Multiply
Ok

Biff
 
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

Change the slope of line graph with the use of spinbutton in Excel VBA 1
Red cell for negative numbers in Excel 1
How can I get excel to accept larger workbooks 2
Small Business.. 1
How do I increase viewable cell character count limit in Excel? 2
Row Height > 409.50 10
Excel Spreadsheets keep moving 0
Can you change the relative reference of a cell in an Excel formul 4

Back
Top