View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
wjohnson
 
Posts: n/a
Default Find percentage ???


Divide 1 Cell by the other and then apply the % format to the cell.

Example (without the format % applied
100 75 0.75
with the format % applied
100 75 75.00%

then in format set how many decimal places you want.


--
wjohnson
------------------------------------------------------------------------
wjohnson's Profile: http://www.hightechtalks.com/m390
View this thread: http://www.hightechtalks.com/t2306229