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.



Posted by Peter on August 23, 2001 10:57 PM

Two suggestions......


Here are two other ways (there must be many other ways) :-

1. By using VLOOKUP and a table of the tariffs
2. By using a macro that is activated either by the user(e.g. via a button or a shortcut key) or automatically via an "event").