MS Excel Formulas

The PV function in Excel is used to calculate the present value of an investment based on a series of regular payments and a constant interest rate. The function syntax is: Syntax =PV(rate, nper, pmt, [fv], [type]) Arguments rate – The interest rate per period. nper – The number of payment periods. pmt – The […]

The PPMT Function is categorized under Excel Financial functions.  The PPMT function in Excel is used to calculate the principal payment of an investment in a specific payment period based on a series of regular payments and a constant interest rate. The function syntax is: Syntax =PPMT( rate, per, nper, pv, [fv], [type] ) Arguments: Rate – This is

The IPMT Function is categorized under Financial functions in MS Excel. The IPMT function in Excel is used to calculate the interest payment of an investment in a specific payment period based on a series of regular payments and a constant interest rate. The function syntax is: Syntax =IPMT(rate, per, nper, pv, [fv], [type]) Arguments:

The SUBSTITUTE function in Excel is a text function that allows you to replace instances of a specific text string within another text string. This can be useful for cleaning up and formatting text data, such as correcting misspelled words or replacing certain characters with others. The SUBSTITUTE function cannot replace more than one string

The REPT function in Excel is a text function that allows you to repeat a given text string a specified number of times Syntax =REPT(text, number_times) Arguments 1. text: text string that you want to repeat. 2. number_times: the number of times that you want to repeat the text string. Example

In Microsoft Excel, the keyboard shortcut CTRL+E is used to activate the Flash Fill feature. Flash Fill is a tool that automatically fills values in a column based on a pattern that it recognizes in the adjacent column. For example, if you have a list of names in a column and you want to extract

The FIND function in Excel is a text function that allows you to find the position of a specified substring within a text string. It can be used to manipulate text data in various ways, such as extracting parts of a text string or replacing specific characters within a text string. Syntax  =FIND(find_text, within_text, [start_num])

MID Function splits the data from the middle of the character. If you want to remove any character from left or right from a cell in Excel, then you should use LEFT Function, right function. Syntax =MID (text, start_num, num_chars) Text: the text string from which you want to extract characters start_num: the position at

The RIGHT function in Excel is a text function that allows you to extract a specified number of characters from the right side of a text string. It can be used to manipulate text data in various ways, such as extracting file extensions or extracting last names from full names. Syntax  =RIGHT(text, [num_chars]) Arguments  text

The LEFT function in Excel is a text function that allows you to extract a specified number of characters from the left side of a text string. It can be used to manipulate text data in various ways, such as splitting names or addresses into separate fields or extracting specific parts of a text string.