Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|