[FONT="]How to tell following criteria in if function[/FONT]
[FONT="]Calculate the service cost for each vehicle using the “Logical IF” considering table below. (All values in LKR)[/FONT]
<colgroup><col span="6" width="64" style="width: 48pt;"><col width="72" style="width: 54pt;"></colgroup><tbody style="margin: 0px; padding: 0px; border: 0px; font-weight: inherit; vertical-align: baseline;">
</tbody>
- Employees who are in grade 1 are subject to 1% of basic salary
- Emoloyees in grade 2 are subjected to 2% of basic salary
- Employees in grade 3 are subjected to 3% of basic salary
[FONT="]Calculate the service cost for each vehicle using the “Logical IF” considering table below. (All values in LKR)[/FONT]
Car | Van | Lorry | Bus | Truck | Motorbike | |
Full | 3500 | 4000 | 5000 | 5500 | 6000 | 1350 |
Wash | 500 | 500 | 750 | 800 | 750 | 350 |
<colgroup><col span="6" width="64" style="width: 48pt;"><col width="72" style="width: 54pt;"></colgroup><tbody style="margin: 0px; padding: 0px; border: 0px; font-weight: inherit; vertical-align: baseline;">
</tbody>