### 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?

=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…