C5>C6 (if C5 is greater then TRUE, otherwise FALSE).If they are equal, the outcome is TRUE, otherwise the outcome is FALSE). Some examples of logical tests that you can use with the IF function include: You can use anything as a logical test provided Excel can determine whether the outcome is TRUE or FALSE. It then outputs a result based on the outcome of that test. The IF function works by performing a logical test that can only have one of two outcomes - TRUE or FALSE. =IF(logical test, value if true, value if false) The IF() function has the following syntax: ![]() You may not know you need it yet, but once you know how to use it, you won't want to live without it. ![]() ![]() The IF statement is a simple function in Excel that is one of the building blocks you need when you are working with large spreadsheets.
0 Comments
Leave a Reply. |