percentage

[angie]

I have a text box that I would like it to figure a price from another text box



=[Finance Price]*IIf([Finance Price]>=1000,0.05)

If the Finance Price is greater than 1000 I would like it to discount that price by 5%

Thanks

[June7]

Now subtract the result of that expression from [Finance Price].

What should be the percentage factor if less than or equal to 1000 - 0? Include that as the False parameter in the IIf().

Advise not to use spaces in any names (nor punctuation/special characters with exception of underscore).