Can I enable numbers to automatically display a letter in a cell depending on a number range in another cell?

Question

Can I enable numbers to automatically display a letter in a cell depending on a number range in another cell?

I am a teacher and as part of my paper work it would be useful if I could use numbers to display a letter (grade A, B, C etc) depending on a number range in another cell.

For example:

Name	Mark	Grade
John Smith	56	C
Jane Johnson	64	B
Michael Watson	78	A

lets say for instance a Grade C was anything between a 50 and 60. Is it possible to set up a table that will automatically enter the grade depending on the numerical value in the Marks column?

Many thanks.

Ryan Butler.

Posted on Jun 10, 2011 12:59 AM

Reply

Answer 1

KOENIG Yvan

Level 8

41,807 points

Jun 10, 2011 4:27 AM in response to Ryan L Butler

Question asked and answered several times !

In C2, the formula is :

=IF(ISBLANK(B),"",VLOOKUP(B,look_up :: A:B,2))

Read iWork Formulas and Functions User Guide to learn the behavior of the used functions.

Yvan KOENIG (VALLAURIS, France) vendredi 10 juin 2011 13:27:02

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

Reply

Answer 2

Jun 11, 2011 3:18 AM in response to KOENIG Yvan

Than you for your reply,

I'm a novice when is comes to formulas and functions, I was unsure of what to search for.

Your answer is confusing, could you go into more detail about how it works? (I've read the user guide but it's not making much sense).

Regards.

Ryan.

Reply

Answer 3

KOENIG Yvan

Level 8

41,807 points

Jun 11, 2011 3:33 AM in response to Ryan L Butler

I apologize but my scholar English don't allow me to be more clear than iWork Formulas and Functions User Guide.

What aren't you understanding ?

Yvan KOENIG (VALLAURIS, France) samedi 11 juin 2011 12:32:55

iMac 21”5, i7, 2.8 GHz, 4 Gbytes, 1 Tbytes, mac OS X 10.6.7

Please : Search for questions similar to your own before submitting them to the community

To be the AW6 successor, iWork MUST integrate a TRUE DB, not a list organizer !

Reply

Answer 4

Jun 11, 2011 4:37 AM in response to KOENIG Yvan

I've just figured it out.

Thank you so much for your help, this small piece of advice is going to change the way my team at work do thier assessment.

Thanks again.

Ryan

Reply