Most Used Excel Functions and Formula Details

Most Used Excel Functions, Examples and Resources

Probably you are not the only one out there who wants to improve Excel skills. It is always great to learn how to create professional spreadsheets and present data that will “wow” your boss.

Check this Excel Functions category and learn about the most common formulas & functions to get closer to working more effectively in Excel!

How to use Excel OR function

Excel OR function returns true if any argument is true. Other Languages and Syntax Details are as listed.

How to use Excel AND function

Excel AND function returns true if all of its arguments are true. Other Languages and Syntax Details are as listed.

How to Use IFERROR in Excel

Excel IFERROR function returns a value you specify if a formula evaluates to an error; otherwise, returns the result of the formula. Other Languages and Syntax Details are as listed.

How to use Excel RAND and RANDBETWEEN functions

How to use Excel RANDBETWEEN function

Excel RANDBETWEEN function returns a random number between the numbers you specify. Other Languages and Syntax Details are as listed.

How to use Excel RAND function

Excel RAND function returns a random number between 0 and 1. Other Languages and Syntax Details are as listed.

How to use Excel LEFT function

Excel LEFT function returns the leftmost characters from a text value. Other Languages and Syntax Details are as listed.

How to use Excel RIGHT function

Excel RIGHT function returns the rightmost characters from a text value. Other Languages and Syntax Details are as listed.

How to use Excel HLOOKUP function

Excel HLOOKUP function looks in the top row of an array and returns the value of the indicated cell. Other Languages and Syntax Details are as listed.

How to use Excel CONCATENATE function

Excel CONCATENATE function joins several text items into one text item. Other Languages and Syntax Details are as listed.

How to use Excel ISBLANK ISTEXT ISNUMBER function

How to use Excel ISTEXT function

Excel ISTEXT function returns true if the value is text. Other Languages and Syntax Details are as listed.

How to use Excel ISNUMBER function

Excel ISNUMBER function returns true if the value is a number. Other Languages and Syntax Details are as listed.

How to use Excel ISBLANK function

Excel ISBLANK function returns true if the value is blank. Other Languages and Syntax Details are as listed.