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
332 views
in Spread Sheet by (27.3k points)
closed by

Prepare a statement showing advance tax collected form the employees @ 10% of the yearly salary from those who receive Rs. 500000 or more

Employees Yearly salary
Fijo 855000
Joshy 650000
Roby 720000
Bose 425000
Prince 570000
Binoy 380000

1 Answer

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

Procedure: 

Step 1 – Open a new blank worksheet in LiberOffice Calc. 

Step 2 – Enter the following details in respective cells.

A B
1 Employees Yearly salary
2 Fijo 855000
3 Joshy 650000
4 Roby 720000
5 Bose 425000
6 Prince 570000
7 Binoy 380000

Step 3 – Select the range A2: A7, From Data Tools menu, select ‘Name a Range’ and give name as “Employees” and click (OK) button.

Step 4 – Enter the text /formula in the following cells.

C
1 Advance Tax
2 = IF (B2>=500000, B2*10%, 0)
3
4
5
6
7

Step 5 – Copy formula to C3: C7 to the last employee.

Step 6 – Enter “Total Advance Tax” in cell B8 and enter the formula ‘‘SUM C2: C7” to get total amount.

Output:

Fijo 85500
Joshy 65000
Roby 72000
Prince 57000

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.

...