have a look at the AND function
=if(and(a223,a2<24),1,2)

--
Don Guillett
SalesAid Software

"Jakefoot" wrote in message
...
I am trying to create a formula that says yes when a number is greater
than
23 but less than 24 and says no when a number is less than 23 or greater
than
24.
I can only figure out how to do one or the other but not both. Thank you.