To Edit A Formulae

Terry · Mar 4th, 2002, 05:11 AM

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 · Mar 4th, 2002, 05:56 AM

Quote:

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 · Mar 4th, 2002, 05:57 AM

In column F:

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

Mar 4th, 2002, 05:57 AM	#3
Anne Troy MrExcel MVP Join Date: Feb 2002 Location: Allentown, PA Posts: 2,510	In column F: =if(or(c2<30,c2>49),"Invalid","") __________________ ~Anne Troy

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 4th, 2002, 05:11 AM	#1
Terry New Member Join Date: Mar 2002 Posts: 4	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)