IIF Statement with a twist

K

krc547

I have this already in place, but I need it to also look at the MotherBaby
Field and if it is checked then it over rides this and inputs a default of
$2256

Rate: IIf([Age]<=4,1589,IIf([Age] Between 5 And 8,1648,IIf([Age] Between 9
And 11,1697,IIf([Age] Between 12 And 14,1787,IIf([Age] Between 15 And
19,1865,0)))))
 
M

Marshall Barton

krc547 said:
I have this already in place, but I need it to also look at the MotherBaby
Field and if it is checked then it over rides this and inputs a default of
$2256

Rate: IIf([Age]<=4,1589,IIf([Age] Between 5 And 8,1648,IIf([Age] Between 9
And 11,1697,IIf([Age] Between 12 And 14,1787,IIf([Age] Between 15 And
19,1865,0)))))
Click to expand...


Try using:

Rate: IIf(MotherBaby, 2256, Switch(Age<=4,1589, Age<=8,1648,
Age<=11,1697, Age<=14,1787, Age<=19,1865, True,0))
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

IIF Statements 1
Date Brackets as an IIf statement 3
Complex Switch Function or Maybe it should be IIF 2
IIF Statement to calculate aging buckets 7
IIf statement vs Select Case statement 1
IIf Statement in Query Criteria 1
Iif statement and time format 2
Why does this Nested IIF statement add AS fields 11

Top