I am trying to create a table that returns values based on a set of criteria. A is a formula that generates a numeric value. The criteria are as follows:
If A<1, return -4
If 1<A<2, return -3
If 2<A<3, return 1
If 3<A, return 4

I then want to use this table and, based on the value of A, return the correct value. I am having difficulty for the values that are less than 1 and greater than 3. Any ideas on how to setup a table or generate the values that I would like without doing a long nested if?

Thank you!