Im looking to put in a formula for a mileage claim form.
The form has the vehicle type, fuel type & capacity and depending on what you drive depends on the amount you can reclaim so I want the mileage rate to default automatically once those 3 cells are filled in.
Also if you have a passenger you get an extra 5p per passenger per mile so ideally Id like to encorporate this into the formula.
Any help will be greatly received
The form has the vehicle type, fuel type & capacity and depending on what you drive depends on the amount you can reclaim so I want the mileage rate to default automatically once those 3 cells are filled in.
Also if you have a passenger you get an extra 5p per passenger per mile so ideally Id like to encorporate this into the formula.
Any help will be greatly received