Re: need to determine a text value of a field based upon a number

From: Frank Kabel (frank.kabel_at_freenet.de)
Date: 05/26/04 

Date: Wed, 26 May 2004 23:49:26 +0200

Hi
if you onl have integer values try
=IF(AJ1=3,"call not connected",IF(AND(A1>=1,A1<=10,A1<>3,A1<>7),"call
is connected","not defined")) 

--
Regards
Frank Kabel
Frankfurt, Germany
"Paul D" <anonymous@discussions.microsoft.com> schrieb im Newsbeitrag
news:1312b01c4436a$27ef8720$a501280a@phx.gbl...
> need to determine a text value of a field based upon a
> number.
> I have a Field AJ that contains a number 1,2,3,4,8
>    If the number is 1,2,4,5,6,8,9,10 Text Value is "call
> is connected"
>    If the number is  3 Text Value is "call not connected"
>
> How do I put my statement together?