Hidden features in PASS or FAIL in MS-Excel

In MS Excel, there are lots of functions and formulas that have the same duties in other programming languages such as HTML, Java, JS and others such as Python and SQL.

However, the IF function is known to be one of the strongest commands when talking about programming in general.

Breakdown of the above function

The syntax of the  above-detailed function that is IF is known to be where:

• the logical given test is a condition the user wants to test. However, it can be known to be a logical expression or a value or even a reference.
• testing the value if true, this is the value that will be returned if the condition is said to be right or true.
• testing the value if false, in this case, the return becomes false when tested and it is false.

Note:

The IF function can also be used in many ways such as the following:

1. Simple IF statements

2. The Nested IF statements

3. Using the IF statement with other functions, for example, =IF(SUM(A1:A10)>100 and so on.

PRACTICAL APPROACH

1. Click in the cell in which you want the answer to appear, that is the PASS or FAIL

2. Press the equal sign (=) once

3. Type IF

4. Open bracket

5. A1> 78

6. Apply comma

7. Add inverted commas or quote

8. Type Pass

9. Quote again

10. Apply comma

11. Apply inverted commas again

12. Type Fail

13. Quote again

14. Close the bracket

15. Press the Enter key once to get your answer or result.

About Author

SURF

See author's posts