Try this:

=IF(AND(C4=50,C4<=252),C4,"")

--
Biff
Microsoft Excel MVP


"j5b9721" wrote in message
...
I need to enter a # into a cell C4

down the page in C33 I need a formula
that will accept the # entered in C4 if
it is between these two numbers 50 & 252