how can i get %. like 100+85+75+96=89.0% Elvis Perez 03.09.2006 17:34:02 I want the pecentage like 100+85+75+96=89.0%

RE: how can i get %. like 100+85+75+96=89.0% kassie 03.09.2006 18:07:01 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: [Quoted Text] > I want the pecentage like 100+85+75+96=89.0%

RE: how can i get %. like 100+85+75+96=89.0% kassie 03.09.2006 18:09:02 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: [Quoted Text] > I want the pecentage like 100+85+75+96=89.0%

Re: how can i get %. like 100+85+75+96=89.0% "Trevor Shuttleworth" <Trevor[ at ]Shucks.demon.co.uk> 03.09.2006 22:21:11 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 Perez[ at ]discussions.microsoft.com> wrote in message news:D79B1A35-81B5-433B-93B6-6D23ECC4086C[ at ]microsoft.com... [Quoted Text] >I want the pecentage like 100+85+75+96=89.0%

Re: how can i get %. like 100+85+75+96=89.0% Jaleel 04.09.2006 07:06:01 Hi, Try this: =AVERAGE(100,85,75,96)/100 Change the to % Regards, Jaleel "Trevor Shuttleworth" wrote: [Quoted Text] > 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 Perez[ at ]discussions.microsoft.com> wrote in message > news:D79B1A35-81B5-433B-93B6-6D23ECC4086C[ at ]microsoft.com... > >I want the pecentage like 100+85+75+96=89.0% > > >