Microsoft Excel Function Library

Excel Function Library, lists and explains all Microsoft Excel functions categorically with easy examples for free.

Financial

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

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

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.

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

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.

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.

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

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.

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

Logical

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

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

OR function tests multiple logical conditions at the same time.

Text

CLEAN function is used to remove non-printable characters.

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

DOLLAR function converts a number value to text.

EXACT function is used to compare different text strings.

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

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

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

T function checks whether the supplied value is a text or not.

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

REPT function repeats a text string, a given number of times.

UPPER case function converts text to uppercase.

Date & Time

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

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.

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

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

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.

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

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.

Lookup & Reference

OFFSET function

Math & Trig

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

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

SUMIFS function performs the SUM function with multiple criteria.

SUMIF function performs the SUM function with single criteria.

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

Statistical

Statistical functions

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.

MAX function returns with the larger of two values.

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

Information

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.

Web

ENCODEURL function converts URL to coded form.

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