IIF Statement with a twist

  • Thread starter Thread starter Guest
  • Start date Start date
G

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


Try using:

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