formula

[ExcelDummy]

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.

 

[Kevin B]

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.

 

[Billy Liddel]

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

 

[Sean Timmons]

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