If function

[madheen]

[FONT=&quot]How to tell following criteria in if function[/FONT]

• 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=&quot] [/FONT]
[FONT=&quot]Calculate the service cost for each vehicle using the “Logical IF” considering table below. (All values in LKR)[/FONT]
[TABLE="width: 456"]
<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;">[TR]
[TD="width: 64, align: right"][/TD]
[TD="class: xl63, width: 64, align: right"]Car[/TD]
[TD="class: xl63, width: 64, align: right"]Van[/TD]
[TD="class: xl63, width: 64, align: right"]Lorry[/TD]
[TD="class: xl63, width: 64, align: right"]Bus[/TD]
[TD="class: xl63, width: 64, align: right"]Truck[/TD]
[TD="class: xl63, width: 72, align: right"]Motorbike[/TD]
[/TR]
[TR]
[TD="class: xl63"]Full[/TD]
[TD="class: xl63, align: right"]3500[/TD]
[TD="class: xl63, align: right"]4000[/TD]
[TD="class: xl63, align: right"]5000[/TD]
[TD="class: xl63, align: right"]5500[/TD]
[TD="class: xl63, align: right"]6000[/TD]
[TD="class: xl63, align: right"]1350[/TD]
[/TR]
[TR]
[TD="class: xl63"]Wash[/TD]
[TD="class: xl63, align: right"]500[/TD]
[TD="class: xl63, align: right"]500[/TD]
[TD="class: xl63, align: right"]750[/TD]
[TD="class: xl63, align: right"]800[/TD]
[TD="class: xl63, align: right"]750[/TD]
[TD="class: xl63, align: right"]350

[/TD]
[/TR]
</tbody>[/TABLE]

 

[arthurbr]

Hi
is this some kind of homework?