Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH A FORMULA
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH A FORMULA
margin as a % is:
=(F65534-E65534)/E65534 Format cell as % HTH "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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH A FORMULA
"EmanJR" wrote in message
... 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 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. -- David Biddulph |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
HELP WITH A FORMULA
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 "Tim M" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) |