Saturday, May 31, 2014

yogi_Compute Class Size Value Based On Table Of Number Of Students In Class And Class Size

                                         Google Spreadsheet   Post  #1657
Yogi Anand, D.Eng, P.E.      ANAND Enterprises LLC -- Rochester Hills MI   May-31-2014
post by Steve Brantley: (!category-topic/docs/spreadsheets/Tt4Tzr2_xtc)
need formula: if cell value = range 1 then input a, if range 2 then input b, etc.

I am recording the number of students attending a classes in a spreadsheet. That number ranges anywhere from 2 to more than 100.  I want to have another column called class size in which the number of students is labeled a size 1-5 based on the number of students who attended. The ranges would be 1-9, 10-19, 20-29, 30-39, 40 + . I'm looking for a formula that would take the number of students and output the class size. for example cell m24 has a value of 33 and I want the "class size" value '4' output into cell n24.