!value!!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; array = 64!can be any value!
value!Checks whether a value is not text (blank cells are not text), and returns TRUE or FALSE!is the value you want tested: ...
value!Checks whether a value is text, and returns the text if it is, or returns double quotes (empty text) if it is not!is ...
value!Checks whether a value is text, and returns TRUE or FALSE!is the value you want to test. Value can refer to a cell, ...
value!Converts non-number value to a number, dates to serial numbers, TRUE to 1, anything else to 0 (zero)!is the value you ...
value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...
value,format_text!Converts a value to text in a specific number format!is a number, a formula that evaluates to a numeric ...
value,value_if_error!Returns value_if_error if expression is an error and the value of the expression itself otherwise!is ...
value1,value2,.!Calculates standard deviation based on an entire population, including logical values and text. Text and ...
value1,value2,.!Calculates variance based on the entire population, including logical values and text. Text and the logical ...