• 100% Satisfaction Guarantee
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

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