To Edit A Formulae

[Terry]

I need to edit a column,lets say column F to insure that a text Invalid Code is displayed if column C is containing less than 30 or more than 49 (Numbers)

 

[Aladin Akyurek]

On 2002-03-04 04:11, Terry wrote:
I need to edit a column,lets say column F to insure that a text Invalid Code is displayed if column C is containing less than 30 or more than 49 (Numbers)

Not sure I understood your question, but how about:

=IF(OR(COUNT(C:C)<30,COUNT(C:C)>49),"Invalid Code","")
This message was edited by Aladin Akyurek on 2002-03-04 06:02

 

[Anne Troy]

In column F:

=if(or(c2<30,c2>49),"Invalid","")