| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Calculate duty payable
I need to create a formula in excel 2010 which will calculate motor vehicles duty.
The duty currently payable is $3 for every $100 (or part of $100) of its value. However the duty on vehicles valued at $45 000 or more (not including motor cycles, buses for more than 9 people including the driver, hearses and invalid conveyances) is $1350 plus $5 for every $100 (or part of $100) over $45 000. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| any good accounts payable templates? | Excel Discussion (Misc queries) | |||
| How do I calculate duty times | New Users to Excel | |||
| accounts payable aging report | Excel Worksheet Functions | |||
| due date for payable invoice | Excel Worksheet Functions | |||
| Using Excel for Accounts Payable - Comprehensive | Excel Worksheet Functions | |||
Threaded Mode
