Percentages in Excel

K

Karl

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
 
B

Bob Phillips

=this_machine/original_system_score

and format that resultant cell as percentage.

--

HTH

Bob Phillips

(remove nothere from the email address if mailing direct)
 
N

Niek Otten

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

=B1/A1

and format as percentage
 
K

Karl

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

What should I put in that part of the formula?
 
B

Bob Phillips

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)
 
Top