Arithmetic or math formula function

[tigerbreeze]

I'm trying to set up a calculated function based on a percentage, i.e.,

4% of total up to $20.00. If total is more than $20.00, then 4% up to
$20.00 and 1.5% of total over $20.00.

Could someone PLEASE help me with the formula or code I need - I have been
driving myself crazy trying to figure it out. Thanks!!!!

 

[Graham R Seach]

IIf(xyz <= 20, xyz*0.04, 0.8+((xyz-20)*0.015))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia

 

[tigerbreeze]

Thanks so much Graham!!!!! What quick service!!!
Wendy