Try this:
=LOOKUP(B2,{0,250,300},{"Far Below ","Below ",""}&"Basic")

Does that help?
--------------------------

Regards,

Ron
Microsoft MVP (Excel)

(XL2003, Win XP)


"Charles Tippie" wrote in message
...
I have a long list of CST scores for our students and would like to run an
If
formula to recognize if a students score is far below basic, basic, or
advanced.

Im thinking the formula would look like this and I need it for the scores
listed below.
Column B Column C
2 350 (if B2300 but b2<350 write Basic)

Basic is 300 to 350
Below Basic 250-300
Far Below Basic 250