I need Formula help
 

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

I need Formula help
 

=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

I need Formula help
 

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

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

regards
FSt1

"j5b9721" wrote:

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

I need Formula help
 

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

I need Formula help
 

Something different:

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

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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

I need Formula help
 

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

I need Formula help
 

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

"Ragdyer" wrote:

Something different:

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

--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"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

I need Formula help
 

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



"j5b9721" wrote in message
...
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