View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Otto Moehrbach[_2_] Otto Moehrbach[_2_] is offline
external usenet poster
 
Posts: 1,071
Default Need Help Fast! How to Calculate a sales percentage

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

"JacoPeanut" wrote in message
...
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!!