How do you write a formula for if cell a is less than 88 then return 2 but if cell a is greater than 91 then return 0 and if it is anything in between those two numbers then return 1?

Answer 1

=if(a < 88, 2, if(a > 91, 0, 1))

Which says:

if a less than 88 return 2 else if a greater than 91 then return 0 else return 1 (since a is greater than or equal to 88 and less than or equal to 91).

I assume "between" in your question means inclusive - otherwise there is nothing in your question which states what to do when cell a is 88 or 91.

Depending upon your spreadsheet program, the commas may need to be replaced by semicolons.