If with reference

  • Thread starter Thread starter Pran
  • Start date Start date
P

Pran

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
 
Hi,

Here is a rather short approach

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

and copy down.
 
Back
Top