Any IIF wiz out there?
Fields are as follows:
AmountPaid
AmountCharged
Status
If [Status] = 201 or 202 and [AmountPaid] >=$500 or <$500 but >= 80% of [AmountCharged], then result is [AmountPaid] x 1.25, else result is [AmountPaid]
Challenging for me at least, I'm sure someone out there can whip this up in a few seconds.
Fields are as follows:
AmountPaid
AmountCharged
Status
If [Status] = 201 or 202 and [AmountPaid] >=$500 or <$500 but >= 80% of [AmountCharged], then result is [AmountPaid] x 1.25, else result is [AmountPaid]
Challenging for me at least, I'm sure someone out there can whip this up in a few seconds.