What Are Excel Functions?
Below is the list of the most important 100+ Excel functions and their formula usage. These Excel functions are categorized into the following:
 Financial Functions
 Logical Functions
 Text Functions
 Date and Time Functions
 Lookup & Reference Functions
 Math Functions
 Statistical Functions
 Information Functions
Key Takeaways
 Excel functions are classified into financial, logical, text, date and time, lookup & reference, math, statistical, and information functions.
 Excel functions like IRR, MIRR, NPER, NPV, PMT, PPMT, Price, PV, Interest Rate, XIRR, and Yield help find investment interest, understand potential returns and expenses, and provide insights into the Internal Rate of Return.
 Excel functions are essential for converting numbers to ASCII characters. The AND function returns TRUE if all conditions are true, while the IFERROR function returns a specific value if an error is returned.
List Of Excel Functions
#1 – Financial Functions
#2 – 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 
–

Leave a Reply