set minimum value for calculated field

[Guest]

Hi. I want to set a minimum value for a calculated field in a query.
Basically I am multiplying a field by a percentage, but when the number is
under 25.00 I want it to come back with 25.00.

MPF: [VendorPaymentAmt]*0.0021

I guess maybe I need an iif statement added to this, something like:

iif(<=25.00, "25.00)

but I can't make that work. What am I missing. Thanks in advance.

Trace

 

[Guest]

Try this

MPF: IIF([VendorPaymentAmt]<25,25,[VendorPaymentAmt])*0.0021