Arithmetic or math formula function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
IIf(xyz <= 20, xyz*0.04, 0.8+((xyz-20)*0.015))

Regards,
Graham R Seach
Microsoft Access MVP
Sydney, Australia
 
Back
Top