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

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Elvis Perez - 03 Sep 2006 18:34 GMT

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

Reply to this Message

kassie - 03 Sep 2006 19:07 GMT

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

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

Reply to this Message

kassie - 03 Sep 2006 19:09 GMT

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

Reply to this Message

Trevor Shuttleworth - 03 Sep 2006 23:21 GMT

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

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

Reply to this Message

Jaleel - 04 Sep 2006 08:06 GMT

Hi,

Try this:

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

Change the to %

Regards,

Jaleel

> Looks more like an average than a percentage
>
[quoted text clipped - 11 lines]
>
> >I want the pecentage like 100+85+75+96=89.0%

Reply to this Message