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

  • Thread starter Thread starter Paul D
  • Start date Start date
P

Paul D

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?
 
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"))
 
Back
Top