Monday, June 20, 2022

Excel Formula (हिन्‍दी)

 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