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?
Ok, what I'm asking is what you want the multiplied result to be if the initial number was 100?
Ok. So do you want 102.45 in another column or do you want to change the 100 to 102.45?
Ok, to modify a column like that would require writing a macro. What column currently has the existing price?
Also, which version of Excel are you using?
Hello, I'm Wes, and I'll be assisting you today.
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.