Hi Tim
Its not helping... I need the number enterd in C4 to be also entered into
C33 only if it is between 50 and 252... as the other cells in the page
connected to C33 misfunction. the same goes for the true false command

"Tim Zych" wrote:

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


"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