| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Margin/markup formula for Excel
I am trying to insert a formula to calculate a percentage of margin/markup.
Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? |
|
#2
|
|||
|
|||
|
profit =(Sale Price/Cost Price) -1
"Wardo" wrote in message ... I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? |
|
#3
|
|||
|
|||
|
Wardo wrote:
I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? There are two different measurements here. Markup: =SP/CP % and Margin: =(SP-CP)/CP % |
|
#4
|
|||
|
|||
|
Cost in A1, price in B1
markup is =(B1-A1)/A1 or =(B1/A1)-1 margin =(B1-A1)/B1 or =1-(A1/B1) Regards, Peo Sjoblom Regards, Peo Sjoblom "Wardo" wrote: I am trying to insert a formula to calculate a percentage of margin/markup. Example cost = $7.00 divided by 30 % = $10.00. My cost is 7.00, my sale price is 10.00. Can anyone help with this formula? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Simple formula doesn't quite add up | Excel Discussion (Misc queries) | |||
| Formula displays does not calculate | Excel Discussion (Misc queries) | |||
| how do I make a formula NOT change when the data range is moved? | Excel Discussion (Misc queries) | |||
| Converting an Excel formula to an Access query formula | Excel Discussion (Misc queries) | |||
| I want the results of a formula to show in cell, NOT THE FORMULA! | Excel Discussion (Misc queries) | |||
Linear Mode
