| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#7
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#8
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
