You don't tell us what formula you used.
But probably you mean something like

=IF(AND(A1=41,A1<=46),"yes","no")

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

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