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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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" wrote in message
...
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