# 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#### Free Book

#### Recent Posts

- How to Get the Last Day of the MonthAug 13, 2017 | Formulas
- How to Get the Current Sheet NameAug 13, 2017 | Formulas
- How to Extract the First Name From an Email AddressAug 13, 2017 | Formulas

#### Recent Tweets

- Check out the powerful new transform data by example plug in for #Excel howtoexcel.org/tips-and-trick… https://t.co/Q7JPqXsruX
- Export your #Excel data into separate workbooks based on the values in a given column!howtoexcel.org/vba/how-to-exp… https://t.co/6V1ZKc431f
- @AlexanderJPeace Doesn't everyone? 😂