Help with Formula for Gradebook

[KAT0200]

Hi,

I am a Kindergarten teacher and I am trying to create a formula that would allow me to enter my test grades in. It would automatically give it a four point value. I.E. if my test was ten points, and I entered 10 in column c than a 4 would appear in column d. If I entered a 0-3 than a 1 would appear. 4-6 would be a 2 and 7-9 would be a 3. I have attached a screenshot that shows the page in the file. Any advice would be much appreciated

Krystal

 

[Teeroy]

Hi and welcome to the forum.

Try the following formula in D2 (assuming the first row is a header) and copy down:

=LOOKUP(C2,{0,1;4,2;7,3;10,4})

 

[KAT0200]

Perfect!

Thank you

 

[Teeroy]

You're welcome.