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 WesPCDr Your Own Question
WesPCDr
WesPCDr, Information Systems Manager
Category: Microsoft Office
Satisfied Customers: 1507
Experience:  Microsoft Office Specialist
21171802
Type Your Microsoft Office Question Here...
WesPCDr is online now
A new question is answered every 9 seconds

HOW TO MULTIPLY A COLUMN BY 2.45%

Customer Question

HOW TO MULTIPLY A COLUMN BY 2.45%
Submitted: 1 year ago.
Category: Microsoft Office
Expert:  Bryan replied 1 year ago.

So if you have the value 100 in A1, and you want the new value in B1, what value should show in B1? 245? 2.45?

Customer: replied 1 year ago.
I'm lost I don't know excel at all sorry
Expert:  Bryan replied 1 year ago.

Ok, what I'm asking is what you want the multiplied result to be if the initial number was 100?

Customer: replied 1 year ago.
102.45
Expert:  Bryan replied 1 year ago.

Ok. So do you want 102.45 in another column or do you want to change the 100 to 102.45?

Customer: replied 1 year ago.
Change the 100 to 102.45 in the entire column. I want to increase prices on my column of 500 items to reflect an increase of 2.45%?
Expert:  Bryan replied 1 year ago.

Ok, to modify a column like that would require writing a macro. What column currently has the existing price?

Expert:  Bryan replied 1 year ago.

Also, which version of Excel are you using?

Expert:  WesPCDr replied 1 year ago.

Hello, I'm Wes, and I'll be assisting you today.

Expert:  WesPCDr replied 1 year ago.

You need to put a formula in the next column to get the value you want.

If the number is ***** column A1.

Use this formula: =A1*2.45%

Then copy and paste that cell into the other columns and it will automatically calculate the formula.