Functions (alphabetical)

List of important Microsoft Excel functions provided alphabetically.

A

ABS function is used to turn negative values into positive one.

ACCRINTM function returns the accrued interest of a security (usually a bond) that pays interest at maturity.

AND function tests a number of logical conditions set by a user.

C

CLEAN function is used to remove non-printable characters.

CONCATENATE function is used to join different text strings to a single string.

COUNT function calculates how many cells/numbers are present in a selected range of cells.

COUNTA function counts cells that are not empty.

COUNTBLANK function used to count the number of blank cells in a range of cells.

COUNTIF function is used to count cells that meet a criterion.

COUNTIFS function counts the number of cells based on single or multiple criteria.

CUMIPMT function calculates the cumulative interest paid between the start date and the end date.

D

DAY function is used to extract a day number (1 to 31) from a date given.

DATE function is used to combine three different values (of date, month and year) to form a date.

E

ENCODEURL function converts URL to coded form.

EXACT function is used to compare different text strings.

F

FVSCHEDULE function returns the future value of an investment (an initial principal) after applying series of compound interest rates.

FV function calculates the future value of an investment.

H

HOUR function is used to extract an hour component between  0 (12:00 A.M.) to 23 (11:00 P.M.)

I

IF function checks whether a specified condition is met or not.

ISPMT function calculates the amount of interest paid on a loan/ investment for a specific period.

INTRATE function calculates the interest rate for a fully invested security.

ISNUMBER function checks whether a cell has a number or text value.

ISODD function checks whether a cell’s data has odd or even numbers.

ISERROR function checks whether a value is an error or not

ISLOGICAL function tests whether a value is a logical or not.

ISTEXT function tests whether a value is a text or not.

ISBLANK function tests whether a value is blank or not.

INFO function returns with information about the current operating environment.

CELL function returns with cell’s information regarding formatting, location, and contents etc.

L

LARGE function returns with the largest numerical value in a list.

LOWER function returns with the lowerest numerical value from a list.

M

MAX function returns with the larger of two values.

MIN function returns with the minimum value from a set of values.

MONTH function returns with a month number from 1 to 12.

N

NOW function returns with the current date and time which is keep updated whenever you open the worksheet.

NETWORKDAYS function returns with a number of working days between two dates after excluding weekends and holidays.

NPV function calculates the net present value of an investment by using a discount rate and a series of future payments.

N function converts a value to a number.

O

OR function tests multiple logical conditions at the same time.

P

PMT function is used to calculate the periodic payment for a loan.

PPMT function calculates the principal value of an investment for a given period.

PV function is used to get the present value/ current worth of the future cash flows that will receive at a future date.

PROPER function is used to capitalize each starting letter of a text string while ignoring numbers and punctuation.

R

RECEIVED function calculates the amount of return at maturity of fully invested security.

ROUND function used to round a number to the decimal places.

S

SMALL function (To find out k-th smallest values e.g.2nd smallest value)

SUBSTITUTE function is used to replace a specific text in a text string.

Statistical functions

SUMPRODUCT function first multiplies corresponding arrays, then returns with the sum.

SUMIFS function performs the SUM function with multiple criteria.

SUMIF function performs the SUM function with single criteria.

SYD function returns the sum-of-years’ digits depreciation of an asset for a specific period.

T

TIMEVALUE function returns with an accurate text value in the decimal number of the time.

TRIM function is used to remove irregular spaces between words which may appear while importing data from another application.

TODAY function is useful when you need a current date in a worksheet and it remains updated whenever you open the worksheet.

U

UPPER case function converts text to uppercase.

Y

Year function is used to extract 4-digit year number from a given Excel’s format date.

YEARFRAC function to get a fractional value representing fractional years between two dates.

Copyright © 2016 - 2017 Explainry.com | All Rights Reserved