HELP WITH A FORMULA

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

EmanJR - 15 Jun 2006 15:39 GMT

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

Reply to this Message

Tim M - 15 Jun 2006 16:05 GMT

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%.

> 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

Reply to this Message

EmanJR - 15 Jun 2006 18:23 GMT

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

> 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 %
[quoted text clipped - 7 lines]
> > 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

Reply to this Message

Toppers - 15 Jun 2006 16:07 GMT

margin as a % is:

=(F65534-E65534)/E65534

Format cell as %

HTH

Reply to this Message

David Biddulph - 15 Jun 2006 16:07 GMT

>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
[quoted text clipped - 5 lines]
> can
> Stay Above where i need to. Help me if you can. Thanks

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.

Signature

David Biddulph

Reply to this Message