Check if number in range

Question

How do I check if a number is in a range of numbers (not a range of cells). For example in many programming languages I can write a >= 1 && a <= 7. How do I express this in Google Sheets?

Answer 1

IF(AND(logical_expression1, logical_expression2), value_if_true, value_if_false)

EDIT: IF(AND(a1 >=1, a1 <= 7),value_if_true, value_if_false)

https://support.google.com/docs/table/25273?hl=en