Percentages in Excel

Hi,

I'm testing a lot of PCs and I need to work out the score of each machine as
a percentage of the benchmark system's score.

I want to enter the number of seconds it took a PC to perform a task into an
excel cell, I then want excel to tell me what percentage of the original
system's score this time represents.

Can anyone tell me what formula I need to use?

Any help much appreciated.

Karl

=this_machine/original_system_score

and format that resultant cell as percentage.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Karl" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm testing a lot of PCs and I need to work out the score of each machine
as
> a percentage of the benchmark system's score.
>
> I want to enter the number of seconds it took a PC to perform a task into
an
> excel cell, I then want excel to tell me what percentage of the original
> system's score this time represents.
>
> Can anyone tell me what formula I need to use?
>
> Any help much appreciated.
>
> Karl
>
>

With the benchmark in A1 and your score in B1, enter this formula in C1:

=B1/A1

and format as percentage

--
Kind regards,

Niek Otten

"Karl" <[email protected]> wrote in message
news:[email protected]...
> Hi,
>
> I'm testing a lot of PCs and I need to work out the score of each machine
> as
> a percentage of the benchmark system's score.
>
> I want to enter the number of seconds it took a PC to perform a task into
> an
> excel cell, I then want excel to tell me what percentage of the original
> system's score this time represents.
>
> Can anyone tell me what formula I need to use?
>
> Any help much appreciated.
>
> Karl
>
>

Thanks bob, but what does "this_machine" stand for?

What should I put in that part of the formula?

"Bob Phillips" wrote:

> =this_machine/original_system_score
>
> and format that resultant cell as percentage.
>
> --
>
> HTH
>
> Bob Phillips
>
> (remove nothere from the email address if mailing direct)
>
> "Karl" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I'm testing a lot of PCs and I need to work out the score of each machine
> as
> > a percentage of the benchmark system's score.
> >
> > I want to enter the number of seconds it took a PC to perform a task into
> an
> > excel cell, I then want excel to tell me what percentage of the original
> > system's score this time represents.
> >
> > Can anyone tell me what formula I need to use?
> >
> > Any help much appreciated.
> >
> > Karl
> >
> >
>
>
>

Thanks!

"Niek Otten" wrote:

> With the benchmark in A1 and your score in B1, enter this formula in C1:
>
> =B1/A1
>
> and format as percentage
>
> --
> Kind regards,
>
> Niek Otten
>
> "Karl" <[email protected]> wrote in message
> news:[email protected]...
> > Hi,
> >
> > I'm testing a lot of PCs and I need to work out the score of each machine
> > as
> > a percentage of the benchmark system's score.
> >
> > I want to enter the number of seconds it took a PC to perform a task into
> > an
> > excel cell, I then want excel to tell me what percentage of the original
> > system's score this time represents.
> >
> > Can anyone tell me what formula I need to use?
> >
> > Any help much appreciated.
> >
> > Karl
> >
> >
>
>
>

The timing of the machine whose rating you want a percentage of the
original. You would normally put that value in a cell, and use the cell
reference.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)

"Karl" <[email protected]> wrote in message
news:[email protected]...
> Thanks bob, but what does "this_machine" stand for?
>
> What should I put in that part of the formula?
>
> "Bob Phillips" wrote:
>
> > =this_machine/original_system_score
> >
> > and format that resultant cell as percentage.
> >
> > --
> >
> > HTH
> >
> > Bob Phillips
> >
> > (remove nothere from the email address if mailing direct)
> >
> > "Karl" <[email protected]> wrote in message
> > news:[email protected]...
> > > Hi,
> > >
> > > I'm testing a lot of PCs and I need to work out the score of each
machine
> > as
> > > a percentage of the benchmark system's score.
> > >
> > > I want to enter the number of seconds it took a PC to perform a task
into
> > an
> > > excel cell, I then want excel to tell me what percentage of the
original
> > > system's score this time represents.
> > >
> > > Can anyone tell me what formula I need to use?
> > >
> > > Any help much appreciated.
> > >
> > > Karl
> > >
> > >
> >
> >
> >