If vs Ifs Function in Excel (Video in Khmer)

Hello everyone! Today I show you how to use IF and IFS formula in Excel step by step with simple examples and video speak Khmer.

You ever want to check if a condition is true and return one value, but if it's false return another value? For example, if student score is greater than or equal to 50 return "Pass", else return "Fail". Excel have formula called IF for this. But what if you want to check multiple conditions at the same time? For example, check grades A, B, C, D, or Fail? You can use Nested IF (IF in IF) or the new IFS function!

Let's look at how to use all of them below.

1. How to Use IF Formula in Excel

IF function help you check a single condition. If condition is true, Excel return first value. If condition is false, Excel return second value.

Formula Syntax:

=IF(logical_test, value_if_true, value_if_false)

Example:

If student score is in cell A2 and passing score is 50:

=IF(A2>=50, "Pass", "Fail")

• If A2 is 75 ➔ Pass
• If A2 is 40 ➔ Fail

Watch video below for step by step guide in Khmer:

2. How to Use Nested IF (IF in IF) in Excel

When you need to test more than 1 condition in older Excel, you put another IF inside the value_if_false part. This is called Nested IF.

Formula Syntax:

=IF(condition1, value1, IF(condition2, value2, value3))

Example:

To calculate grades based on score in cell A2:

=IF(A2>=80, "Grade A", IF(A2>=70, "Grade B", IF(A2>=50, "Grade C", "Fail")))

Watch video below to see how to write IF in IF step by step in Khmer:

3. How to Use IFS Formula in Excel (Excel 2019 & 365)

IFS function is modern replacement for Nested IF. It allow you to check multiple conditions without writing many IF words and confusing closing parentheses ))).

Formula Syntax:

=IFS(logical_test1, value_if_true1, [logical_test2, value_if_true2], ...)

Example:

Same grade calculation using IFS:

=IFS(A2>=80, "Grade A", A2>=70, "Grade B", A2>=50, "Grade C", TRUE, "Fail")

Note: Putting TRUE at the end acts like default fallback value (else condition).

💡 Quick Tip: If you use Excel 2019, Excel 2021, or Excel 365, always prefer using IFS over Nested IF. IFS is much cleaner to read and maintain. However, if your file will be opened by someone using old Excel 2013 or 2010, stick with Nested IF so the formula won't show #NAME? error for them!

📚 Useful Resources

• Countif vs Countifs Function in Excel (Video in Khmer)
• XLOOKUP vs INDEX+MATCH Function in Excel (Video in Khmer)
• How to Calculate Number of Students (Male/Female, Pass/Fail) in Excel
• Top 15 Basic Excel Formulas Every Beginner Should Know
• Free Download PDF - 50 Popular Excel Formulas Cheatsheet (Khmer Language)