Excel functions

EFFECT worksheet function for Excel

The EFFECT worksheet function for Excel returns the effective annual interest rate. EFFECT worksheet function Below is the syntax of the EFFECT function. Syntax =EFFECT(Nominal_rate, Npery) Arguments Here are the arguments of the EFFECT function. Argument Description Nominal_rate The nominal interest rate. Npery The number of compounding periods per year. Examples Example 1 Note: For […]

Excel functions

Excel functions list Below are the list of Excel functions in alphabetical order. Function name Type and description ABS function Math and trigonometry: Returns the absolute value of a number ACCRINT function Financial: Returns the accrued interest for a security that pays periodic interest ACCRINTM function Financial: Returns the accrued interest for a security that pays interest at […]

LEN worksheet function for Excel – Reference

The LEN worksheet function in Excel returns the number of characters in a text string. LEN worksheet function Here is the syntax of the LEN function. Syntax =LEN(reference) Arguments Reference – A text string or cell range. Example(s) Example 1 Example 2 Example 3 Excel functions  Reference home  Excel Effects home

MID worksheet function for Excel – Reference

Overall, the MID worksheet function in Excel returns the characters from the middle of a text string, given a starting position and length. MID worksheet function Here is the syntax of the MID function. Syntax =MID(Text, Start_num, Num_chars) Arguments Below are the arguments of the MID function. Argument Description Text A text string from which […]

Using the FILTER function in Excel – Snapshot

This short snapshot simply provides a reference of using the FILTER function in Excel. Keep in mind, this reference does not go into full detail of using this function. On the whole, it is a snapshot of the function. We pattern this example from the following function. LET function Snapshot of using the FILTER function […]