View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.misc
FSt1 FSt1 is offline
external usenet poster
 
Posts: 3,942
Default 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