Need Help Fast! How to Calculate a sales percentage

[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!!

 

[Otto Moehrbach]

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

 

[ryguy7272]

With sales in A2 and COGS in B2, put this in C2:
=B2/A2

Right-click, format cells, percentage, OK.

HTH,
Ryan--

 

[David Biddulph]

You'll have to tell us what you mean by "the sales percentage", and you'll
have to tell us what is in your two cells.

If A2 contains the sales in one period and B2 contains the sales in the next
period, and you want to know the percentage increase from the one period to
the next, then it would be =B2/A2-1, formatted as percentage.