!value,value_if_na!!Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression!is any value or expression or reference!is any value or expression or reference!
value!Returns an integer representing the data type of a value: number = 1; text = 2; logical value = 4; error value = 16; ...
value!Returns the sheet number of the referenced sheet!is the name of a sheet or a reference that you want the sheet number ...
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 ...
value,value_if_na!Returns the value you specify if the expression resolves to #N/A, otherwise returns the result of the expression!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 ...
value1,value2,.!Counts the number of cells in a range that are not empty!are 1 to 255 arguments representing the values and ...
value1,value2,.!Counts the number of cells in a range that contain numbers!are 1 to 255 arguments that can contain or refer ...