View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.newusers
Jaleel Jaleel is offline
external usenet poster
 
Posts: 187
Default how can i get %. like 100+85+75+96=89.0%

Hi,

Try this:

=AVERAGE(100,85,75,96)/100

Change the to %

Regards,

Jaleel

"Trevor Shuttleworth" wrote:

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%