So I'm (terribly) writing a formula to check the Class, then validate it against the date in Column B or Column D depending on the information in Column I. But I need to put it all into 1 formula as the check.
e.g.
IF(AND([CLASS]="ARCH*",[COURSE1]>=TODAY()),"YES","NO") But I need an Or to add the rest of the calculations
AND([CLASS]="SCIE*",[COURSE2]>=TODAY()),"YES","NO")
AND([CLASS]="HIST*",[COURSE1]>=TODAY()),"YES","NO")
So how do i add multiple checks under and or? =If(or(and)(and))?]
Also if this guess figure out, can you help explain how it's nested... like I search the googles for if(or(and) and I got no results and i have had a similar question in the past that i tried applying but that failed
TABLE1
e.g.
IF(AND([CLASS]="ARCH*",[COURSE1]>=TODAY()),"YES","NO") But I need an Or to add the rest of the calculations
AND([CLASS]="SCIE*",[COURSE2]>=TODAY()),"YES","NO")
AND([CLASS]="HIST*",[COURSE1]>=TODAY()),"YES","NO")
So how do i add multiple checks under and or? =If(or(and)(and))?]
Also if this guess figure out, can you help explain how it's nested... like I search the googles for if(or(and) and I got no results and i have had a similar question in the past that i tried applying but that failed
TABLE1
ROW/COLUMN | COURSE1 DATE (COLUMN B) | COURSE2 DATE (COLUMN D) | CLASS (COLUMN I) | FORMULA (COLUMN S) |
---|---|---|---|---|
1 | 1/11/22 | 1/11/22 | ARCH 100 | |
2 | 1/11/22 | 11/10/22 | ARCH 200 | |
3 | 1/10/22 | 1/11/22 | SCIE 100 | |
4 | 11/11/22 | 11/11/22 | SCIE 200 | |
5 | 1/12/22 | 10/18/21 | HIST 100 | |
6 | 10/18/21 | 11/16/05 | HIST 200 |