If with reference
 

Hi,

I have workbook as follow:

A1 is "Employee" or "Spouse" or "Dependent"
B1 is age of A1

I wish in C1 :

if A1 is "Employee" or "Spouse", result will be Yes

But, if A1 is "dependent", then should refer to the B1 column, which is, if
age is less then 20, result also Yes, otherwise No.

Could you advise me?

Regards,
Pran

If with reference
 

Try in C1:
=IF(COUNTA(A1:B1)<2,"",IF(OR(A1={"Employee","Spous e"}),"Yes",IF(AND(A1="dependent",B1<20),"Yes","No" )))
Copy down

Ok? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Pran" wrote:
I have workbook as follow:

A1 is "Employee" or "Spouse" or "Dependent"
B1 is age of A1

I wish in C1 :

if A1 is "Employee" or "Spouse", result will be Yes

But, if A1 is "dependent", then should refer to the B1 column, which is, if
age is less then 20, result also Yes, otherwise No.

Could you advise me?

Regards,
Pran

If with reference
 

Thx, max....

another one,

but tomorrow.....

"Max" wrote:

Try in C1:
=IF(COUNTA(A1:B1)<2,"",IF(OR(A1={"Employee","Spous e"}),"Yes",IF(AND(A1="dependent",B1<20),"Yes","No" )))
Copy down

Ok? Click YES below
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Pran" wrote:
I have workbook as follow:

A1 is "Employee" or "Spouse" or "Dependent"
B1 is age of A1

I wish in C1 :

if A1 is "Employee" or "Spouse", result will be Yes

But, if A1 is "dependent", then should refer to the B1 column, which is, if
age is less then 20, result also Yes, otherwise No.

Could you advise me?

Regards,
Pran

If with reference
 

Welcome, glad it helped.
--
Max
Singapore
http://savefile.com/projects/236895
Downloads:27,000 Files:200 Subscribers:70
xdemechanik
---
"Pran" wrote in message
...
Thx, max....

another one,
but tomorrow.....

If with reference
 

Hi,

Here is a rather short approach

=IF(AND(A1="dependent",B1=20),"No","Yes")

and copy down.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Pran" wrote:

Hi,

I have workbook as follow:

A1 is "Employee" or "Spouse" or "Dependent"
B1 is age of A1

I wish in C1 :

if A1 is "Employee" or "Spouse", result will be Yes

But, if A1 is "dependent", then should refer to the B1 column, which is, if
age is less then 20, result also Yes, otherwise No.

Could you advise me?

Regards,
Pran