Category: Functions

COUNTIFS function

This function will conditionally count items in a range based on given criteria. Syntax COUNTIFS(Range 1, Criteria 1, Range 2, Criteria 2,…) Range 1 (required) – This is the range to which the first criteria is...

Read More

INT function

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...

Read More

SUMIFS function

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....

Read More

ABS function

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....

Read More

PROPER function

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...

Read More

UPPER function

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...

Read More

LOWER function

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...

Read More

RIGHT function

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....

Read More

LEFT function

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...

Read More

IFNA function

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...

Read More

TRUE function

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....

Read More

FALSE function

This function will return the FALSE value. This is the same as just entering the value FALSE Syntax FALSE() There are no arguments for this function. Example In this example we return the FALSE value....

Read More
Loading

Follow Us

Free Book

Recent Tweets

Categories

Pin It on Pinterest