If this and or this and then

[NGB82KS]

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

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

 

[Fluff]

How about

=IF(or(AND([CLASS]="ARCH*",[COURSE1]>=TODAY()),AND([CLASS]="SCIE*",[COURSE2]>=TODAY()),AND([CLASS]="HIST*",[COURSE1]>=TODAY())),"YES","NO")

 

[NGB82KS]

How about

=IF(or(AND([CLASS]="ARCH*",[COURSE1]>=TODAY()),AND([CLASS]="SCIE*",[COURSE2]>=TODAY()),AND([CLASS]="HIST*",[COURSE1]>=TODAY())),"YES","NO")

Fluff, is there anything in excel you dont know brother?
The code doesn't like my Wildcard "ARCH*" in that formula, but if i replace it with an exact "ARCH 100"it works for that one, any suggestions? or just make more ands?

 

[Fluff]

Missed you had wildcards, try it like

=IF(or(AND(left([CLASS],4)="ARCH",[COURSE1]>=TODAY()),AND(left([CLASS],4)="SCIE",[COURSE2]>=TODAY()),AND(left([CLASS],4)="HIST",[COURSE1]>=TODAY())),"YES","NO")

 

[NGB82KS]

Missed you had wildcards, try it like

=IF(or(AND(left([CLASS],4)="ARCH",[COURSE1]>=TODAY()),AND(left([CLASS],4)="SCIE",[COURSE2]>=TODAY()),AND(left([CLASS],4)="HIST",[COURSE1]>=TODAY())),"YES","NO")

Once again you have saved me about 100 hrs of manually doing this! Cheers!
Can you recommend any other websites I should be looking at for code/formulas (yes,yes other than Mr Excel which is always my 1st stop) to better my knowledge on this stuff?

 

[Fluff]

There are any number of good sites out there. I often look at ExcelJet for formulae, but as I said, there are plenty of others.