I'm trying to get a field which will allow a calculation of a differential discount. So our progressive client discount goes from 10% off to 50% off depending on how much the client purchases of particular stock lines.
I can calculate a simple 20% discount (IF(AND(F9>=200,F9<=299.99),F9*0.8)...