View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Charles Tippie[_2_] Charles Tippie[_2_] is offline
external usenet poster
 
Posts: 2
Default If forumula for 4 conditions

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