IIF Statement with a twist

[Guest]

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)))))

 

[Marshall Barton]

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)))))

Try using:

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