I need Formula help

[Guest]

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

 

[Tim Zych]

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

 

[Guest]

hi,
you really didn't profide enough info but this is it basically.

=IF(AND(C4>=50, C4<=252), TRUE, FALSE)

regards
FSt1

 

[T. Valko]

Try this:

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

 

[Ragdyer]

Something different:

=(C4=MAX(50,MIN(252,C4)))*C4

 

[Guest]

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

 

[Guest]

I thank all of of yous for helping!!! Take care!!!

 

[Tim Zych]

=IF(AND(C4>=50, C4<=252),C4,0)

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