Formula Issues - If then OR if then, else

[SwensrnTaz]

If you could assist me in the following formula, that would be great:

Logic:
If Project Adoption Level = 1 and if Requirements Level Inception = 6, then “Level 1”
Or
If Project Adoption Level = 2 and if Requirements Level Inception = 9, then “Level 2”
Else
“Level 0”

Formula: (These are the formulas I have tried and either get a Syntax or Argument Error)
=IIf([Project Adoption Level]=1,IIf([Requirements Level Inception]=6,"Level 1"),
iif(OR([Project Adoption Level]=2,iif([Requirements Level Inception]=9),"Level 2"),
"Level 0"))

=IIf(OR([Project Adoption Level]=1,IIf([Requirements Level Inception]=6,"Level 1",
iif(OR([Project Adoption Level]=2,iif([Requirements Level Inception]=9,"Level 2",
"Level 0"))))

=IIf(OR([Project Adoption Level]=1,IIf([Requirements Level Inception]=6,"Level 1",)
iif(([Project Adoption Level]=2,iif([Requirements Level Inception]=9,"Level 2",)
"Level 0"))))



In March, I will need to add level 3 criteria, but my assumption is I can use the same logic once I get this working.

I have not worked in Access since 2002 and nothing this significant then. I am working in Access 2007 which is also new to me. Thanks!!

[RayMilhon]

=IIf([Project Adoption Level]=1,IIf([Requirements Level Inception]=6,"Level 1","Level 0"),
iif([Project Adoption Level]=2,iif([Requirements Level Inception]=9),"Level 2","Level 0"),
"Level 0"))

Or you can create a Function Someling like

Public Function SetLevel(ByRef ProjAdop as long, reqlev as long) as string

If ProjAdop = 1 and reqlev = 6 Then
SetLevel = "Level 1"
Else
If ProjAdop = 2 and reqlev = 9 then
SetLevel = "Level 2"
Else
SetLevel = "Level 0"
End if
End if

End function

[RayMilhon]

Ok, something like not someling like. How in the he?? did I miss that?