HELP WITH A FORMULA

E

EmanJR

I need help figuring out a Formula, in my Excel Sheet i have Total COST in
Cell E65534 and in F65534 I have Cost that I charged My Customer. I need a
Formula that will calculate the Margin that I had earned for that
transaction. So that i can figure out what my margins are, cause we all have
to make a certain amount on our margins, and i want to make sure that i can
Stay Above where i need to. Help me if you can. Thanks
 
T

Tim M

Try this formula: =1-E65534/F65534 (Format the cell or cells you will be
putting the formula in as % to 1 decimal.) This should give you the %
markup. for example if the cost of the item was $10 and you charge the
customer $15 the markup would be 33%.
 
D

David Biddulph

EmanJR said:
I need help figuring out a Formula, in my Excel Sheet i have Total COST in
Cell E65534 and in F65534 I have Cost that I charged My Customer. I need
a
Formula that will calculate the Margin that I had earned for that
transaction. So that i can figure out what my margins are, cause we all
have
to make a certain amount on our margins, and i want to make sure that i
can
Stay Above where i need to. Help me if you can. Thanks
Click to expand...

You need to decide whether to express the margin as a percentage of the cost
or percentage of the selling price.

Either =F65534/E65534-1
or =1-E65534/F65534

and format as percentage.
 
E

EmanJR

NOW AT THE BOTTOM OF THE SHEET HOW WOULD I GET AN AVERAGE MARGIN FOR ALL OF
THE ORDERS THAT I HAVE PLACED. Like for an Example I had 35 Orders in 1
Month, and I need to find out the Total Average Margin that i was at for that
Month. Thanks for your help
 
Top