EXCEL IFS Function
The Ifs function in Microsoft Excel is a logical function that allows you to test multiple conditions and return a value based on the first condition that is met.
Syntax:
 =IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], [logical_test3; …)
Arguments or Parameters
logical_test1: first Logical test.
value_if_true1 :Â the value to return if logical test1 is True.
logical_test2: second Logical test
value_if_true2:Â the value to return if logical test2 is True.
Objective: Find the Grade of each applicant. If the test score is above 4, the grade is “A”. If it’s above 2.5, the grade is “B”.            For scores lower than 2.5, the grade is “C”.
 Step 1:
Type = sign in F2 cell
Type Ifs Function
   Step 2:
Type E2>4
Type “,”
Type “Grade A”
Type “,”
   Step 3:
Type E2>2.5
Type “,”
Type “Grade B”
Type “,”
 Step 3:
Type E2<=2.5
Type “,”
Type “Grade C”
Type “,”
Close Bracket “)”
Press Enter
Result: Ifs Function has populated Grace C in cell F2.
Â
Copy the Formula from F2 cell and paste on Range “F3:F20“
