Need Help Urgently!!!!
I have the following:
<colgroup><col span="4"><col><col span="9"></colgroup><tbody>
</tbody>
I have the following:
<tbody> </tbody> | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Need to calculate payable depends on Miles & Services type based on the Miles range. If miles are greater than 20, then additional miles be paid at the 20 miles rate plus miles minus 20 miles * rate. Can someone please help. I tried with index, match formula but when tried with if formula to check the mileage range to pay can not get the right answer. Thank you in advance Don | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col span="4"><col><col span="9"></colgroup><tbody>
</tbody>