I'm working with Google Apps (spreadsheet) and I need to convert results (ranging from 0 to 36) to a maximum of 7 according to the following table.if score is (0-5) result should be 1  if score is (6-9) result should be 2  if score is (10-15) result should be 3  if score is (16-21) result should be 4  if score is (22-26) result should be 5  if score is (27-31) result should be 6  if score is (32-36) result should be 7  Can anyone give me an example of a function doing this?
In Google Spreadsheets, how can I convert a number according to a range?
conversion;google spreadsheets