Text to display Invalid code

Charlie · Mar 4th, 2002, 04:49 AM

Hi, My question is how do I display the text Invalid code if a number is more than 49 or less than 30 in this formula =INDEX(Countries,20,1)

[ This Message was edited by: Charlie on 2002-03-04 04:08 ]

Corni · Mar 4th, 2002, 08:03 PM

What about this formula:

=IF(OR(INDEX(Countries,20,1)>49,INDEX(Countries,20,1)<30),"INVALID CODE",INDEX(Countries,20,1))

[ This Message was edited by: Corni on 2002-03-04 19:06 ]

Charlie · Mar 5th, 2002, 02:07 AM

Firstly thanks for answering, the formula looks good, the only trouble is when its copied down the whole row reads Invalid Code, so I think I must have made a mistake somewhere, perhaps I should have made a cell reference absolute.

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

Mar 4th, 2002, 04:49 AM	#1
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Hi, My question is how do I display the text Invalid code if a number is more than 49 or less than 30 in this formula =INDEX(Countries,20,1) [ This Message was edited by: Charlie on 2002-03-04 04:08 ]

Mar 4th, 2002, 08:03 PM	#2
Corni Board Regular Join Date: Mar 2002 Location: Brampton Posts: 324	What about this formula: =IF(OR(INDEX(Countries,20,1)>49,INDEX(Countries,20,1)<30),"INVALID CODE",INDEX(Countries,20,1)) [ This Message was edited by: Corni on 2002-03-04 19:06 ]

Mar 5th, 2002, 02:07 AM	#3
Charlie Board Regular Join Date: Mar 2002 Posts: 134	Firstly thanks for answering, the formula looks good, the only trouble is when its copied down the whole row reads Invalid Code, so I think I must have made a mistake somewhere, perhaps I should have made a cell reference absolute.