PDA

View Full Version : Help: Auto Calculate Macro



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

Bob Phillips
12-31-2015, 09:38 AM
isn't it just a case of putting the multiplier in cells A2:An say, and then in B2 enter

=50*A2

and copy down?

jcl1988
12-31-2015, 09:49 AM
I added the image. I currently do that but Rather than do 4 different formulas I would rather just a macro to do it for me.

Bob Phillips
12-31-2015, 10:43 AM
I can't get anything from that picture, but you only enter 4 formulas, all the rest are just an autofill.