Please enable JavaScript.
Coggle requires JavaScript to display documents.
EXEL FUNCTIONS - Coggle Diagram
EXEL FUNCTIONS
LOGICAL FUNCTIONs
↓
IF → Tests a condition and returns one value if TRUE and another if FALSE.
↓
AND → Returns TRUE if all conditions are TRUE.
↓
OR → Returns TRUE if at least one condition is TRUE.
↓
NOT → Reverses the logical value of its argument.
↓
IFERROR → Returns a custom value if a formula results in an error.
↓
Purpose: Logical functions help make decisions in formulas.
Excel Functions
↓
↓
PMT → Calculates the payment for a loan based on constant payments and interest rate.
↓
FV → Returns the future value of an investment.
↓
PV → Calculates the present value of an investment.
↓
RATE → Returns the interest rate per period of an investment.
↓
NPV → Calculates the net present value of an investment based on periodic cash flows.
↓
Purpose: Financial functions help perform money-related calculations.
Connection Between Them
↓
Logical functions and financial functions work together to analyze and manage financial data logically and efficiently.
FINANCIAL FUNCTONS