If with reference

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
 
S

Shane Devenshire

Hi,

Here is a rather short approach

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

and copy down.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Coding Help for Beginner 0
VBA for Dependents shortcut menu 0
Need Opinion 1
Help needed regarding calculating time 0
Data Validation and drop-down list using IF, AND and what else? 8
Baffeling IF statement 7
Different Functions in One Cell Cancel Each Other Out - How can I fix this? 1
reverse pasting rows with alternate blank cells 0

Top