IF(logical_test [,value_if_true] [,value_if_false]) 
Returns the value based on a logical test that is either True or False. 
logical_test  The value or expression that can be evaluated to True or False. 
value_if_true  (Optional) The value that is returned if "logical_test" is True. 
value_if_false  (Optional) The value that is returned if "logical_test" is False. 
Remarks 
* For an illustrated example refer to the page under Formulas > Conditional. * This function is not case sensitive when matching text strings. * This function does not support wildcards (? and *). * If the "value_if_true" is left blank then, "value_if_false" must be provided. * If the "value_if_false" is left blank then, "value_if_true" must be provided. * You can nest up to 64 IF functions. * If "logical_test" is true and "value_if_true" is blank, then zero is returned. * If "logical_test" is false and "value_if_false" is blank, then False is returned. * You can use the AND function to return the logical AND for any number of arguments. * You can use the OR function to return the logical OR for any number of arguments. * You can use the NOT function to return the opposite of a True or False value. * You can use the IFS function to return a value based on multiple conditions. * For the Microsoft documentation refer to support.office.com 

1  What value is returned when the logical test returns True. 2  What value is returned when the logical test returns False. 3  What value is returned when the logical test "B2>20" is evaluated. 4  What value is returned when the logical test "B2<30" is evaluated. 5  What value is returned when the condition "text"="text" is evaluated. 6  What value is returned when the condition "TEXT"="text" is evaluated. This function is not case sensitive. 7  What value is returned when the cell "B6" is passed to the function ISBLANK. 8  What value is returned when the cell "B6" is compared to an empty string. 9  What value is returned when the cell "B2" is evaluated using multiple nested IF functions. 10  What value is returned when the cell "B3" is evaluated using multiple nested IF functions. 11  What value is returned when the AND function is evaluated. 12  What value is returned when the OR function is evaluated. 13  What value is returned when the logical test is True and the "value_if_false" is not provided. 14  What value is returned when the logical test is False and the "value_if_true" is blank. 15  What value is returned when the logical test is True, the "value_if_true" is blank and the "value_if_false" is not provided. 16  What value is returned when the logical test is True and the "value_if_true" is blank. 17  What value is returned when the logical test is False and and the "value_if_true" is blank. 18  What value is returned when the logical test is False, the "value_if_true" is blank and the "value_if_false" is not provided. 
© 2020 Better Solutions Limited. All Rights Reserved. © 2020 Better Solutions Limited Top