Ms. Excel 2010 | How to use IF Function | How to use or calculate score result PASS OR FAIL

1Likes

121Views

2017Nov 30

The IF function can perform a logical test and return one value for a TRUE result, and another for a FALSE result. For example, to "pass" scores above 70. More than one condition can be tested by nesting IF functions. The IF function can be combined with logical functions like AND and OR. Purpose: The IF function use to test for a specific condition Return value The values you supply for TRUE or FALSE Use the IF function to test for or evaluate certain conditions, and then react differently depending on whether the test was TRUE or FALSE. For example, let's say you want to assign either "Pass" or "Fail" to students based on a test score. In that case, you need to test the sore itself (for each student) and then return either "Pass" or "Fail". ------------------------------------- MS Excel: How to use the IF Function (WS) This Excel tutorial explains how to use the Excel IF function with syntax and examples. Description The Microsoft Excel IF function returns one value if the condition is TRUE, or another value if the condition is FALSE. The IF function is a built-in function in Excel that is categorized as a Logical Function. It can be used as a worksheet function (WS) in Excel. As a worksheet function, the IF function can be entered as part of a formula in a cell of a worksheet. Please read our IF-THEN-ELSE (VBA) page if you are looking for the VBA version of the IF statement as it has a very different syntax. TIP: If you have Excel 2016, try the new IFS function (and specify up to 127 conditions). Syntax The syntax for the IF function in Microsoft Excel is: IF( condition, [value_if_true], [value_if_false] ) Parameters or Arguments condition The value that you want to test. value_if_true Optional. It is the value that is returned if condition evaluates to TRUE. value_if_false Optional. It is the value that is return if condition evaluates to FALSE. Returns The IF function returns value_if_true when the condition is TRUE. The IF function returns value_if_false when the condition is FALSE. Applies To Excel 2016, Excel 2013, Excel 2011 for Mac, Excel 2010, Excel 2007, Excel 2003, Excel XP, Excel 2000 Type of Function Worksheet function (WS) Example (as Worksheet Function) Let's look at some Excel IF function examples and explore how to use the IF function as a worksheet function in Microsoft Excel: ------------------------------------- WANT TO LEARN MORE PLEASE GO TO MY BLOGSPOT BELLOW: ---------- https://samchamreunlearning.blogspot.com http://bit.ly/2zAiSzj https://chamreuntutorial.blogspot.com http://bit.ly/2AFYCtS Faccebook: / chamreun.sam ------------------------------ MS.EXCEL 2010: http://bit.ly/2hq10Nb ------------------------------- MS.WORD 2010: http://bit.ly/2ibzPq3 ------------------------------- MS.POWERPOINT 2010: http://bit.ly/2hw3lda ----------------------------- SAMCHAMREUN Channel-សំ ចំរើន ឆាណែលតែងតែនាំលោកអ្នកនូវ ចំណេះដឹង គន្លឹះខ្លីៗ និងការកំសាន្ត ។ អរគុណចំពោះគាំទ្រតាមដានការទស្សនា សូមចុច Subscribe នៅយូធូប Share Like និង Comment ដើម្បីទទួលបានវីដេអូថ្មីៗ ពី SAM CHAMREUN Channel -------------------------------------- Thank for watching for more videos Please Subscribe on our youtube channel: / @chamreunibm6133 --------------------------------------