View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.newusers
Trevor Shuttleworth Trevor Shuttleworth is offline
external usenet poster
 
Posts: 1,089
Default how can i get %. like 100+85+75+96=89.0%

Looks more like an average than a percentage

Add them up, divide by the number of entries

=(100+85+75+96)/4

If you do want it to look like a percentage:

=(100+85+75+96)/4/100 and format as percentage

Regards

Trevor


"Elvis Perez" <Elvis wrote in message
...
I want the pecentage like 100+85+75+96=89.0%