InterviewSolution
Saved Bookmarks
| 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) |
|