Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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..... |
#5
Posted to microsoft.public.excel.newusers
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Nesting a sheet name reference within a cell reference??? | Excel Discussion (Misc queries) | |||
Using an offset formula for the reference in a relative reference | Excel Worksheet Functions | |||
Formulas that reference cells that reference another cell | Excel Discussion (Misc queries) | |||
Row reference increment but preserve column reference | Excel Worksheet Functions | |||
Macro to Reference Column Next to Current Reference | Excel Discussion (Misc queries) |