Need help with builder formula

[shantmov]

I need some help building an expression in Microsoft Access. The first 50 dollars of an item sold is charged a 10% commission rate. For example, ($50.00 x 10%). Any amount over 50 dollars is charged 8%. For example, an item sold at $75 will have a formula of ($50 x 10% + $25 x 8%). I have literally been trying for the past 2 days. Any and all help is greatly appreciated.

[June7]

Commission: x * 0.10 + IIf(x>50, (x-50) * 0.08, 0)

[shantmov]

Commission: x * 0.10 + IIf(x>50, (x-50) * 0.08, 0)

You don't understand the headache you just saved me. Thanks for the help.