HELP WITH A FORMULA
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%.
"EmanJR" wrote:
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
|