One way:
=if(and(a1=41,a1<=46),"it's between","outside")



velopoav wrote:

Everytime i type that condition into an if statement it doesnt calculate the
number correctly... what am i doing wrong?

--

Dave Peterson