|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 13th, 2009, 05:09 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
how do i set up a profit margin formula
new to excel-- i would like to set up a formula to calculate the margin
percentage. ex -- cost divided by retail= markup, markup divided by 1. the markup 1.00/1.50 = .667 .667/1.667=40% gross margin 
|
|
#2
May 13th, 2009, 05:33 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i set up a profit margin formula
=(A1/B1)/(1+(A1/B1)) format as percent
wayne wrote: new to excel-- i would like to set up a formula to calculate the margin percentage. ex -- cost divided by retail= markup, markup divided by 1. the markup 1.00/1.50 = .667 .667/1.667=40% gross margin
|
|
#3
May 13th, 2009, 05:37 PM
posted to microsoft.public.excel.misc
|
|||
|
|||
|
how do i set up a profit margin formula
Hi Wayne,
In your example the margin is 50% not 40% the formula to use is Cell A1 = Selling price Cell A2=Cost =1/(1+(A2/A1)) other way is to simple deduct the cost from the Selling price divided by 100 =(A1-A2)/100 "wayne" wrote: new to excel-- i would like to set up a formula to calculate the margin percentage. ex -- cost divided by retail= markup, markup divided by 1. the markup 1.00/1.50 = .667 .667/1.667=40% gross margin
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
