• 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: 11 months ago.
Category: Microsoft Office
Expert:  Bryan replied 11 months 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 11 months ago.
I'm lost I don't know excel at all sorry
Expert:  Bryan replied 11 months ago.

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

Customer: replied 11 months ago.
102.45
Expert:  Bryan replied 11 months ago.

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

Customer: replied 11 months 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 11 months ago.

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

Expert:  Bryan replied 11 months ago.

Also, which version of Excel are you using?

Expert:  WesPCDr replied 11 months ago.

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

Expert:  WesPCDr replied 11 months 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.