!logical_test,value_if_true,value_if_false!logical_test!!Checks whether a condition is met, and returns one value if TRUE, and another value if FALSE!is any value or expression that can be evaluated to TRUE or FALSE!is the value that is returned if Logical_test is TRUE. If omitted, TRUE is returned. You can nest up to seven IF functions!is the value that is returned if Logical_test is FALSE. If omitted, FALSE is returned!
Locking objects has no effect unless the sheet is protected. To help protect the sheet, choose Format on the Home tab, and ...
Locking objects has no effect unless the sheet is protected. To help protect the sheet, choose Format on the Home tab, and ...
logical1,logical2,.!Checks whether all arguments are TRUE, and returns TRUE if all arguments are TRUE!are 1 to 255 conditions ...
logical1,logical2,.!Checks whether any of the arguments are TRUE, and returns TRUE or FALSE. Returns FALSE only if all arguments ...
logical_test,value_if_true,value_if_false!logical_test!Checks whether a condition is met, and returns one value if TRUE, ...
lookup_value,lookup_array,match_type!Returns the relative position of an item in an array that matches a specified value ...
lookup_value,table_array,col_index_num,range_lookup!Looks for a value in the leftmost column of a table, and then returns ...
lookup_value,table_array,row_index_num,range_lookup!Looks for a value in the top row of a table or array of values and returns ...
lower_limit,upper_limit!Returns the error function!is the lower bound for integrating ERF!is the upper bound for integrating ...