Hi,

I would like to know whether anyone knows how to do the following, in excel.

Say that I am grading somebody, and my grading options are from 1 to 4. I want to create a condition in a cell, that when someone is uncertain about the score that they want to give, and they assign 2 or 3, then the cell would automatically read the highest value, that is 3.

Thanking you!

Quote:

---

Originally Posted by vbg1980

Hi,

I would like to know whether anyone knows how to do the following, in excel.

Say that I am grading somebody, and my grading options are from 1 to 4. I want to create a condition in a cell, that when someone is uncertain about the score that they want to give, and they assign 2 or 3, then the cell would automatically read the highest value, that is 3.

Thanking you!!

---

You could do this with an if statement but that would get kind of long.

Take a look at the vlookup function. If you create a small table somewhere on your spreadsheet with the possible entry values and the value you want assigned you can lookup what they enter and get the value that should be assigned.

Hope that makes sense.

I have tried that today, not sure I'm getting it.

I will persist tomorrow, and tell you how that goes. Thanks for your answer :)

Post the spreadsheet on here and I'll take a look at it when I have a minute.

Thanks for your help :) I managed to figure it out - I used IF function after all and it wasn't that complicated because it was an either or answer I wanted.

Thanks!