by John MacDougall | Jun 26, 2016 | Math
This function will rounds a number down to the nearest integer. Syntax INT(Number) Number (required) – This is the number you want to round down to the nearest integer. Example In this example find the round down a few numbers. Text values will result in a... by John MacDougall | Jun 19, 2016 | Math
This function will conditionally sum up numbers in a range based on given criteria. Syntax SUMIFS(Sum Range, Range 1, Criteria 1, Range 2, Criteria 2,…) Sum Range (required) – This is the range of numbers to sum. Range 1 (required) – This is the... by John MacDougall | Jun 17, 2016 | Math
This function will return the absolute value of a number. The absolute value is the “positive” part of a number. Syntax ABS(Number) Number (required) – This is the number you want to find the absolute value of. Example In this example find the... by John MacDougall | Jun 5, 2016 | Text
This function will function will capitalize the first letter of each word. Syntax PROPER(Text) Text (required) – This is the text string which you want to capitalize the first letter of each word. Example In this example we capitalize the first letter of each... by John MacDougall | Jun 5, 2016 | Text
This function will convert text to all uppercase letters. Syntax UPPER(Text) Text (required) – This is the text string you want to turn into all uppercase letters. Example In this example we convert some text into uppercase....