1.

Write the command to calculate the State Life Insurance Premium (SLI) of an employee using IF Function. The condition is SLI Premium Rs. 500/-below Basic Pay (BP) of Rs. 15000/- and for others Rs. 800/- (BP is given in cell C3)

Answer»

= IF(C3 < 15000, 500, 800)



Discussion

No Comment Found