Excel Formulas

Showing page 2 of 21
SLN
Financial

Returns the straight-line depreciation of an asset for one period

SYD
Financial

Returns the sum-of-years' digits depreciation of an asset for a specified period

DOLLARDE
Financial

Converts a dollar price expressed as a fraction into a decimal number

DOLLARFR
Financial

Converts a dollar price expressed as a decimal number into a fraction

EFFECT
Financial

Returns the effective annual interest rate

NOMINAL
Financial

Returns the nominal annual interest rate

XNPV
Financial

Returns the net present value for a schedule of cash flows

PROPER
Text

Capitalizes the first letter in each word of a text value

CLEAN
Text

Removes all nonprintable characters from text

DOLLAR
Text

Converts a number to text using currency format

FIXED
Text

Formats a number with a fixed number of decimals

REPLACE
Text

Replaces characters within text

REPT
Text

Repeats text a given number of times

T
Text

Returns the text referred to by value

TEXT
Text

Formats a number and converts it to text

VALUE
Text

Converts a text string that represents a number to a number

EXACT
Text

Checks to see if two text values are identical

UNICHAR
Text

Returns the Unicode character referenced by the given numeric value

UNICODE
Text

Returns the number (code point) corresponding to the first character of the text

UPPER
Text

Converts text to uppercase

Page 2 of 21