IF FUNCTION

 

How to tell following criteria in if function

  • 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

 

Calculate the service cost for each vehicle using the “Logical IF” considering table below. (All values in LKR)

Car Van Lorry Bus Truck Motorbike
Full 3500 4000 5000 5500 6000 1350
Wash 500 500 750 800 750 350


By: Ahamed

Leave a Reply

Your email address will not be published. Required fields are marked *