![]() We use the IF() function in these cases when we want to trigger some further actions or calculations depending on the results of the logical test. when a value in C2 is NOT larger than a value in C3 cell) the formula will return another default value – FALSE. If this statement is true, the formula returns the default value – TRUE. Just place a formula like “=C2>C3” in a cell and press ENTER. Interesting Fact!!! You can use another simpler test in Excel for a certain condition. ![]() Otherwise, it returns the default value FALSE. This formula tests the condition we set (C2=1) and if it is true, the formula returns the text message (“Hello!”). ![]() The simplest IF() function may be written with the first two parameters only.įor example, this formula is absolutely correct: =IF(C2=1,"Hello!") IF something is true, THEN return the first value, ELSE – return then second value. In other words, IF() function is used to test the specific conditions and can be described as the statement:
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. Archives
June 2023
Categories |