Here is an example of what I am trying to do:
IIf Current rank is Less than (([Requiredpts] = >=5), ([Basic1]= >=1), ([Basic2]= >=1), ([Orientation] = >=1),Yes)

IIF Function

I'm kind of confused what you're trying to do. Can you elaborate more? If it's just simply comparing fields it should be something like this
IIF([CurrentPoints]>=[RequiredPoints],"Pass","Fail")

I will try my best Adam:

It is a little more complicated that just straight up points. While you have to have a minimum amount of total points, each rank has minimum required courses also. That is why in the EventsLogT I have attendance points, and then the minimum required courses. It is a series of 0 or 1, 1 if you attended the required class (i.e. Basic1), then also a point for attendance for that event.

So for a new person to advance past LvL 0 they have to have:
[Requiredpts] >=5),
[Basic1] >=1),
[Basic2] >=1),
[Orientation]  >=1

Once they reach they reach LvL 1, reaching LVL 2 would something like this:

Current LVL is Less than LVL 2 requirements =  (([Requiredpts] = >=5), ([Basic3]= >=1), ([Basic4]= >=1), Yes)

So unless you need to know specifically which one they failed, it should just be throwing them all into the criteria
I'm also guessing they have a "current points" field to compare to the total required points? If not just take that out and do RequiredPoints>=5

IIF([CurrentPoints]>=[RequiredPoints] and [Basic1]>=1 and [Basic2]>=1 and [Orientation]>=1,"Pass","Fail")

That got it Adam, Thanks.