Need Help Fast! How to Calculate a sales percentage

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

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
 
R

ryguy7272

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

Right-click, format cells, percentage, OK.

HTH,
Ryan--
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Calculating percentage growth rate from a cumulative figure 4
Excel Average dates help 0
Apply various percentage with sales between a & b, b & c, etc. 2
Access Group by precinct, calculate percentage of older voters 0
Multiple conditions 12
calculate percentage?? 2
Need a formula 5
maintaining constant percentage 1

Top