how can i get %. like 100+85+75+96=89.0%
 

I want the pecentage like 100+85+75+96=89.0%

how can i get %. like 100+85+75+96=89.0%
 

Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 enter =SUM(B2:E2)/4. If you want it displayed as %,
devide by a further 100, format cell as percentage, 1 decimal point -
=SUM(B2:E2)/400, or =(100+85+75+96)/400, or else enter the values as
percentages 1, 0.85, 0.75 and 0.96, and then devide by 4 at the end


"Elvis Perez" wrote:

I want the pecentage like 100+85+75+96=89.0%

how can i get %. like 100+85+75+96=89.0%
 

Same way you did on the calculator? =(100+85+75+96)/4, or with your values
in say B2:E2, then in F2 enter =SUM(B2:E2)/4. If you want it displayed as %,
devide by a further 100, format cell as percentage, 1 decimal point -
=SUM(B2:E2)/400, or =(100+85+75+96)/400, or else enter the values as
percentages 1, 0.85, 0.75 and 0.96, and then devide by 4 at the end


"Elvis Perez" wrote:

I want the pecentage like 100+85+75+96=89.0%

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%

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%