Thread: Gross margin
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Eduardo Eduardo is offline
external usenet poster
 
Posts: 2,276
Default 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?