Use app×
Join Bloom Tuition
One on One Online Tuition
JEE MAIN 2025 Foundation Course
NEET 2025 Foundation Course
CLASS 12 FOUNDATION COURSE
CLASS 10 FOUNDATION COURSE
CLASS 9 FOUNDATION COURSE
CLASS 8 FOUNDATION COURSE
0 votes
191 views
in Use of Spread Sheet in Business Application by (25.6k points)
closed by

Develop the commands to calculate the group insurance premium (Gl) and Tax Deducted at source (TDS) by using the ‘IF’ function. 

1. Rate of GI Rs. 200/- for BP below Rs: 8000/- and for others Rs. 300/-, assuming that BP of employee is given in B2. 

2. TDS 10% of Gross pay, for employees having Gross pay below Rs. 15,000/- and for others, 20%, assuming that the gross pay of the employee is given in F2.

1 Answer

+1 vote
by (27.3k points)
selected by
 
Best answer

1. IF (B2 < 8000, 200, 300) 

2. IF (F2 < 15000, F2*10%, F2*20%)

Welcome to Sarthaks eConnect: A unique platform where students can interact with teachers/experts/students to get solutions to their queries. Students (upto class 10+2) preparing for All Government Exams, CBSE Board Exam, ICSE Board Exam, State Board Exam, JEE (Mains+Advance) and NEET can ask questions from any subject and get quick answers by subject teachers/ experts/mentors/students.

...