How do you return a specific value based on range in Apple Numbers?

I'm working on a spreadsheet in Apple Numbers and need to know the most accurate and efficient way to return a specified value based on a variable input. So I have a fixed table that says: If variable is between 1-5, return A, if variable is between 6-10, return B. Then I simply want to enter the variables in another table to return A or B. How is this done?|||Spreadsheets have some similarity.


In the OpenOffice Calc Spreadsheet I tested this:


=IF(A1%26lt;=5;"A";"B")


It reads: If what was entered in field A1 is less or equal to five then give me an A,


otherwise give me a B.


The A or B will appear in the field that contains the above formula.