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 MoreINT 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 MoreSUMIFS 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 MoreABS 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 MorePROPER 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 MoreUPPER 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 MoreLOWER 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 MoreRIGHT 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 MoreLEFT 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 MoreIFNA 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 MoreTRUE 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 MoreFALSE 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 MoreFree eBook
50 Tips to Master Excel
Subscribe to our newsletter and get a copy of myÂ FREEÂ eBook that'sÂ packed with tips and tricks that willÂ super chargeÂ your Excel skills!
Check your email to confirm subscription and receive your free book.
Unsubscribe any time
Recent Posts

The Complete List Of Excel Keyboard ShortcutsJun 25, 2017  Shortcuts

How To Build Your Pivot TablesJun 7, 2017  Tutorials

How To Transform Data by ExampleMay 20, 2017  Tips & Tricks

How To Create A Pivot TableMay 11, 2017  Tutorials
Recent Tweets

RT @msexcel: Start your week off with some data humor. Every great spreadsheet started somewhere. #MondayMotivation https://t.co/NxJorM08lj

Quick tip: Format numbers as a time using Ctrl + Shift + @ howtoexcel.org https://t.co/nAc9AV39QK

Quick tip: Format numbers in #Excel as dates using Ctrl + Shift + # howtoexcel.org https://t.co/uvvOWWPOdo

Quick tip: Format numbers in #Excel with thousands comma separator and two decimal places using Ctrl + Shift + !â€twitter.com/i/web/status/8â€¦jf

RT @HowToExcelBlog: Quick tip: disable gridlines in a sheet for a clean look in #excel howtoexcel.org https://t.co/qW9dmSX4rp