by John MacDougall | Jun 5, 2016 | Text
This function will convert text to all lower case letters. Syntax LOWER(Text) Text (required) – This is the text string you want to turn into all lower case letters. Example In this example we convert some uppercase text into lower case.... by John MacDougall | Jun 4, 2016 | Text
This function will return the right most characters of a text string based on a number specified. Syntax RIGHT(Text, Number) Text (required) – This is the text string you want to return the right most characters from. Number (optional) – This is the number... by John MacDougall | Jun 4, 2016 | Text
This function will return the left most characters of a text string based on a number specified. Syntax LEFT(Text, Number) Text (required) – This is the text string you want to return the left most characters from. Number (optional) – This is the number of... by John MacDougall | Jun 4, 2016 | Logical
This function will return a specified value if your given expression results in an #N/A error. Only the #N/A! error will result in the alternate value. Syntax IFNA(Expression, Value if #N/A!) Expression (required) – This is part of the formula that is checked... by John MacDougall | Jun 4, 2016 | Logical
This function will return the TRUE value. This is the same as just entering the value TRUE. Syntax TRUE() There are no arguments for this function. Example In this example, we return the TRUE value. =TRUE()
