Scribd
Upload
42 views6 pages

IF Function: Salary Grade

The document contains examples of using IF functions to conditionally assign grades based on salary thresholds, determine government subsidies for citizens based on income and family size, and determine student eligibility for the next class based on certification scores or previous class performance. It also provides examples of formatting rules for cell references, names, and merging/splitting columns in a spreadsheet. The document demonstrates various spreadsheet functions and formatting.

Uploaded by

Tushar Sohale
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
42 views6 pages

IF Function: Salary Grade

The document contains examples of using IF functions to conditionally assign grades based on salary thresholds, determine government subsidies for citizens based on income and family size, and determine student eligibility for the next class based on certification scores or previous class performance. It also provides examples of formatting rules for cell references, names, and merging/splitting columns in a spreadsheet. The document demonstrates various spreadsheet functions and formatting.

Uploaded by

Tushar Sohale
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd

IF Function

Salary Grade
5,000
10,000
15,000
20,000
22,000
7,000
9,000
12,000
20,000
4,500
26,000
Problem Statement:
Condition: If, Salary >=10000 then GradeA, otherwise Grade B.
Citizens Monthly Income Govt. Job #Children Subsidy (Y/N)
C1 7000 Yes 3
C2 8000 No 2
C3 10000 Yes 1
C4 4000 No 2
C5 6500 No 6
C6 4500 Yes 2
C7 9800 No 3
C8 5000 No 1
C9 8700 Yes 1
C10 12000 No 2

Student Certification Previous Class (%) Can Register (to next


class)
Student1 86 74
Student2 80 95
Student3 92 89
Student4 63 51
Student5 67 79
Student6 60 85
Student7 57 85
Student8 95 74
Student9 93 71
Student10 76 52

Note:
Problem statement :
If monthly income is less than 7000 and has
no govt. job and has less than or equal to 2
children, he/she gets the subsidy.

Problem Statement:
If the student has passed the certification test
(scored 80% or higher) or has passed the prev.
class (with 70% or higher), they can register
for the next class.

Names cannot have spaces


Names can be of max 255 characters
Names need to be unique to the sheet or worksheet
Absolute and Relative Cell references
CP SP PAT = SP - CP - Tax
50000 75000
45000 60000
80000 125000
35000 45000
90000 105000
12000 15500

Text to Columns and Merge Multiple columns


Name First Name Last Name Email IDs
Adam Smith
Ethan Hunt
George Anderson
Mary Smith
Jack Williamson
Elizabeth Miller
Jane Adams
Bill Clark

Merge multiple columns


House No. Street Area Complete Address
202 Dalal Street Nehru Nagar
123 77 street 28 maharaja nagar
Tax 5000

You might also like