View Single Post
  #3   Report Post  
Paul Sheppard
 
Posts: n/a
Default


For the first example 1. H2/D2 * 100 - type =H2/D2 and format the cell
as a percentage, Format, Cells and on the number tab under category
select percentage

For the second example 2. G2+H2/D2 * 100 - type =SUM(G2+H2)/D2 ansd
again format the cell as a percentage


--
Paul Sheppard
------------------------------------------------------------------------
Paul Sheppard's Profile: http://www.excelforum.com/member.php...o&userid=24783
View this thread: http://www.excelforum.com/showthread...hreadid=390895