How JustAnswer Works:

  • Ask an Expert
    Experts are full of valuable knowledge and are ready to help with any question. Credentials confirmed by a Fortune 500 verification firm.
  • Get a Professional Answer
    Via email, text message, or notification as you wait on our site.
    Ask follow up questions if you need to.
  • 100% Satisfaction Guarantee
    Rate the answer you receive.

Ask John D Your Own Question

John D
John D, Bachelor's Degree
Category: Microsoft Office
Satisfied Customers: 9666
Experience:  Bachelor of Science - Engineering Consultant
53785
Type Your Microsoft Office Question Here...
John D is online now
A new question is answered every 9 seconds

I want to increase several columns of numbers (Dollars) by

This answer was rated:

I want to increase several columns of numbers (Dollars) by 5% in Microsoft Excel for Mac 2011 version 14.2.2. How would I do this without having to multiply each Dollar amount by 5%? Is there a formula?
D4
4 $1,895
5 $2,800
6 $3,495
7 $2,800
8 $4,375
9 $4,825
10 $4,375
11 $2,795
12 $2,395
13 $1,895

Hi,

 

Here is how to do that

 

- In an empty cell type 1.05

- Copy that cell

- Select the cells that you want to apply the 5% to

- Click the Home tab > Paste > Paste Special > Multiply > OK

 

That should do it

 

 

For version 2011 please replace the last step with

 

- Click the Home tab, click the little arrow on the Paste button > Paste Special > Multiply > OK

 

 

John D and 5 other Microsoft Office Specialists are ready to help you