Saved Bookmarks
| 1. |
Write command to calculate state life Insurance Premium (SLI) of employee using the ‘IF’ function. Condition Premium Rs. 350/- below Basic Pay of Rs. 25000 and for others Rs. 450/- (BP is given in cell A3) |
|
Answer» = IF(A3 < 25000, 350, 450) |
|