Check the syntax for the If statement in your version 6. For my version 9 it is : If ( Qty ≥ Buy ; Qty * Pay ; Qty * Each )
if a customer orders a certain quantity of an item, the price goes down. For example, if they order 8 widgets the price is $2.50. If they order 12 or more the price is $1.99. How do I make a calculation for that?
You don't. You lookup the price from a Prices table, using a relationship matching on = ProductID and ≥ Quantity.