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. |