Expression builder - Multiple IF statements

[ne1gold]

so im using the expression builder to try calculate values. But output stays blank :
This is the expression :



=IIf([Job Level FW]>=13,[Sum of core 13-16 FW]/5,0) Or ([Job Level FW] Between 9 And 12,[Sum of 9-12 FW]/15,0) Or ([Job Level FW] Between 7 And 8,[Sum of 7-8 FW]/10,0) Or ([Job Level FW]<=6,[Sum of 1-6 FW]/13,0)

also tried this :

IIf ([Job Level FW] >= 13,[Sum of core 13-16 FW]/5,0)
elseIf ([Job Level FW] between 9 and 12,[Sum of 9-12 FW]/15,0)
elseIf ([Job Level FW] between 7 and 8,[Sum of 7-8 FW]/10,0)
elseIf ([Job Level FW] <= 6,[Sum of 1-6 FW]/13,0)




Any help would be appreciated

[CJ_London]

you need a nested iif and simplify the code

=IIf([Job Level FW]>=13,[Sum of core 13-16 FW]/5, iif([Job Level FW] >8,[Sum of 9-12 FW]/15, iif([Job Level FW] >6,[Sum of 7-8 FW]/10, [Sum of 1-6 FW]/13)))

you don't need the between - if [Job Level FW] equals say 7 the first 2 'iifs' are not met, but are met for the third iif

Strongly recommend loose the spaces or use underscores for field names - use the caption property if you want spa

Also your last iif (<=6) is not required as a test, if it fails all the previous ones, it is the only option - you will never get an option for the 0

[ne1gold]

You saved my life!!! Thanks

[ssanfu]

You saved my life!!!

Wow!! I think I'd be afraid to work for your bosses!!