Need Help Fast! How to Calculate a sales percentage

  • Thread starter Thread starter JacoPeanut
  • Start date Start date
J

JacoPeanut

I am trying to give the sales percentage between two cells and am not sure
how to do it... Any help would be greatly appreciated. I am under a
deadline!!
 
To get the percentage that A1 is of A2, simply divide A1 by A2 and format
the cell that contains the formula as percentage. The formula is =A1/A2
HTH Otto
 
With sales in A2 and COGS in B2, put this in C2:
=B2/A2

Right-click, format cells, percentage, OK.

HTH,
Ryan--
 
Back
Top