Excel functions

## ABS worksheet function for Excel – Reference

In Excel, the ABS worksheet function returns the absolute value of a number, a number without its sign. Basically, the absolute value of a number shows a value of zero or higher. For example, the absolute value of -34 is 34. If you analyze it, then you can view the distance of a number from […]

## CONCAT worksheet function for Excel

The CONCAT worksheet function for Excel allows you to combine multiple ranges of text strings. CONCAT is short for concatenate. Overview of CONCAT worksheet function So, the main key word in the purpose of CONCAT is ranges, which means, CONCAT works as an array function. In other words, you can check values one-by-one within a […]

## 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

## 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 […]

Affiliate stuff – Move up and excel with Excel