Stepped tariff calculations
Posted by Lisa on August 23, 2001 9:40 PM
Can anyone tell me whether there is another way of calculating revenue using a stepped tariff apart from using nested if statements? ie Revenue is calculated by charging a certain rate for the first 500 units, then a different rate for the next 1500 units, a different rate again for the next 1000 units and then another rate for the remaining. The number of units actually purchased is different each time.
I know that it can be done using an IF statement but was wondering if anyone knew of any other ways.
Thanks.