View Single Post
  #8   Report Post  
Posted to microsoft.public.excel.misc
j5b9721 j5b9721 is offline
external usenet poster
 
Posts: 63
Default 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