jcl1988
12-31-2015, 09:15 AM
I have fixed numbers I calculate to a price. I would like to have a macro to auto-calculate all these fix multipliers
Example:
If I am told the cost of something is $50
I do 4 calculates to get 4 different prices:
50 x 3 = 150
50 x 1.6 = 80
50 x 1.5 = 75
50.1.425 = 71.25
I do this calculate for Thousands of "Costs" numbers I am given.
Currently I do a basic math formula and drag it down for all the numbers i need to calculate for.
I prefer to have a macro that would do this calculation for me once I have all the "cost" in column in excel.
Any help would be appreciated.15073
Example:
If I am told the cost of something is $50
I do 4 calculates to get 4 different prices:
50 x 3 = 150
50 x 1.6 = 80
50 x 1.5 = 75
50.1.425 = 71.25
I do this calculate for Thousands of "Costs" numbers I am given.
Currently I do a basic math formula and drag it down for all the numbers i need to calculate for.
I prefer to have a macro that would do this calculation for me once I have all the "cost" in column in excel.
Any help would be appreciated.15073