How do I structure an IF statement if I want to find out if a number is
between two other numbers?

i.e is a cell reference 4 and <12

I have tride numerous combination and can't seem to get it to return the
correct result.