Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gross margin
When calculating gross profit margins using cost and sell price, what does
the formula look like? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gross margin
Hi,
if ssles are in A1 and cost in B1 in C1 enter =A1-B1 If you need to see the %GM in D1 you can enter =C1/A1 format D1 as % If this helps please click yes, thanks "Don Y" wrote: When calculating gross profit margins using cost and sell price, what does the formula look like? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gross margin
"Don Y" wrote: When calculating gross profit margins using cost and sell price, what does the formula look like? If the cost is in A1 and selling in B1 the formula would be =(B1-A1)/A1 Format the cell for percentage. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gross margin
Thanks for the reply. It helped. Let's say i want to create a sheet that
will allow me to change the GP% by entering the desired GP and have it change the sell price to reflect the GP i'm looking for. A1 is cost, A2 is sell price, A3 is the cell i enter the desired GP percent which will automatically change A2 sell price? "James" wrote: "Don Y" wrote: When calculating gross profit margins using cost and sell price, what does the formula look like? If the cost is in A1 and selling in B1 the formula would be =(B1-A1)/A1 Format the cell for percentage. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Gross margin
In A2 use this formula Cell A3 should be formatted percentage. A1+(A1*A3)
"Don Y" wrote: Thanks for the reply. It helped. Let's say i want to create a sheet that will allow me to change the GP% by entering the desired GP and have it change the sell price to reflect the GP i'm looking for. A1 is cost, A2 is sell price, A3 is the cell i enter the desired GP percent which will automatically change A2 sell price? "James" wrote: "Don Y" wrote: When calculating gross profit margins using cost and sell price, what does the formula look like? If the cost is in A1 and selling in B1 the formula would be =(B1-A1)/A1 Format the cell for percentage. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
gross margin | Excel Worksheet Functions | |||
Help in Developing a Multi-Level Gross Margin Chart | Charts and Charting in Excel | |||
Calculation of Gross Margin in a pivot table | Excel Worksheet Functions | |||
gross profit margin formula | Excel Discussion (Misc queries) | |||
How do I make a column that calculates gross margin percentage | Excel Worksheet Functions |