formula
 

I'm trying to create a formula example 99% and above is rated a 5 97%-98%
would be rated a 4 95%-96% would be rated a 3 and 93%-94% would be rated a 2
and 92% and below would be rated a 1 . So in example cell one would have a
score of 96% and cell 2 would show the rating of 3. I hope this makes sense.
--
Thank you
ExcelDummy

formula
 

Create a table with your range of values, something like the following:

A B
0 1
..93 2
..95 3
..97 4
..99 5

And then find the VLOOKUP function in help and reference the lookup table
above to return your value.
--
Kevin Backmann
"ExcelDummy" wrote:

I'm trying to create a formula example 99% and above is rated a 5 97%-98%
would be rated a 4 95%-96% would be rated a 3 and 93%-94% would be rated a 2
and 92% and below would be rated a 1 . So in example cell one would have a
score of 96% and cell 2 would show the rating of 3. I hope this makes sense.
--
Thank you
ExcelDummy

formula
 

Or

=IF(ISBLANK(A3),"",IF(A3=0.99,5,IF(A3=0.97,4,IF( A3=0.95,3,IF(A3=0.93,2,IF(A3<=0.92,1))))))

Peter


"ExcelDummy" wrote:

I'm trying to create a formula example 99% and above is rated a 5 97%-98%
would be rated a 4 95%-96% would be rated a 3 and 93%-94% would be rated a 2
and 92% and below would be rated a 1 . So in example cell one would have a
score of 96% and cell 2 would show the rating of 3. I hope this makes sense.
--
Thank you
ExcelDummy

formula
 

the vlookup for the below would be something like:

=VLOOKUP(yourvalue,A:B,2)

Do NOT use the FALSE option at the end. This will cause any value that does
not exactly match those in column A to return #N/A.

HTH

"Kevin B" wrote:

Create a table with your range of values, something like the following:

A B
0 1
.93 2
.95 3
.97 4
.99 5

And then find the VLOOKUP function in help and reference the lookup table
above to return your value.
--
Kevin Backmann
"ExcelDummy" wrote:

I'm trying to create a formula example 99% and above is rated a 5 97%-98%
would be rated a 4 95%-96% would be rated a 3 and 93%-94% would be rated a 2
and 92% and below would be rated a 1 . So in example cell one would have a
score of 96% and cell 2 would show the rating of 3. I hope this makes sense.
--
Thank you
ExcelDummy