Below is the list of Most Important 100+ Excel Functions along with its usage and formula. These Excel Functions are subdivided into the following –
 Financial Functions
 Logical Functions
 Text Functions
 Date and Time Functions
 Lookup & Reference Functions
 Math Functions
 Statistical Functions
 Information Functions
Financial Functions in Excel
Logical Functions in Excel
AND  If all the supplied conditions are true, it will return TRUE or else FALSE. 
logical1
logical2

IF  This tests the logic given; it the condition is true, then we can get whatever the result we want if FALSE also we can other than the TRUE result value. 
logical_test
value_if_true
value_if_false

IFERROR in Excel IFERROR In ExcelThe IFERROR function in Excel checks a formula (or a cell) for errors and returns a specified value in place of the error.read more  This returns the specific value if the applied formula returns an error result. 
value
value_if_error

NOT  This works indirectly, if the value is TRUE, it will result in FLASE, and if the result is FALSE, it will return TRUE. 
logical

OR in Excel OR In ExcelThe OR function in Excel is used to test various conditions, allowing you to compare two values or statements in Excel. If at least one of the arguments or conditions evaluates to TRUE, it will return TRUE. Similarly, if all of the arguments or conditions are FALSE, it will return FASLE.read more  This is just like the AND function in excel, but if anyone of the supplied is true, it will return TRUE. 
logical1
logical2

TRUE  This is the formula to get TRUE value without manual typing 
–

Text Functions in Excel
Date and Time Functions in Excel
Lookup & Reference Functions in Excel
Math Functions in Excel
Statistical Functions in Excel
Information Functions in Excel
 35+ Courses
 120+ Hours
 Full Lifetime Access
 Certificate of Completion
Leave a Reply