IF Function - Begins With

Thanks! Long time lurker/learner from these forums, first time responding!

I got an answer, but it wasn't the right one. It didn't error out.
I think I'm going to try to do something along the line of the below since it is a number (once my brain can wrap around where this AND function goes along with the AND and ORs I already have going on...)

=IF(AND(C1>=A1,C1<=B1),"between","not between")

(from: http://www.mrexcel.com/forum/excel-q...wo-values.html)