MS Excel Formula
Text |
Date and Time |
Math |
FINANCIAL |
Statistical |
BHTTEXT CHAR CLEAN CODE CONCATENATE DOLLER EXACT FIND FIXED LEFT LEN LOWER MID NUMBERVALUE PROPER REPLACE REPT RIGHT SEARCH SUBSTITUE T TEXT TRIM UNICHAR UNICODE UPPER VALUE |
DATE DATEVALUE DAY DAYS DAYS360 EDATE EMONTH HOUR ISOWEEKNO MINUTE MONTH NOWDAYS NOW SECOND TIME TIMEVALUE TODAY WEEKDAY WEEKNUM WORKDAY YEAR YEARFRAC |
ABS AGGREGATE BASE CEILING COMBIN COMBINA DECIMAL EVEN EXP FACT FLOOR GCD INT LCM LOG MOD PI POWER PRODUCT QUOTIENT RADIAN RAND RANDBETWEEN ROUND SQRT SUBTOTAL SUM SUMIF TRUNC |
CUMIPMT DB DDB FV PMT SLN |
AVERAGE AVERAGEIF COUNT FREQUENCY FORCAST MAX MIN MEDIAN PERMUTATION |
LOOKUP |
LOGICAL FORMULA
|
|||
CHOOSE HLOOKUP VLOOKUP HYPERLINK INDEX TRANSPOSE MATCH |
AND OR NOT XOR IF IFERROR TRUE FALSE |
Financial Formula
1. PMT ( FOR EMI CALCULATION )
2. IPMT ( Interest include in EMI )
3. PV (Principal Amount )
4. FV ( Future Value)
No comments:
Post a Comment