Author name: Ankit IT Solutions

IF ERROR Function In Excel In Hindi, Microsoft – IF ERROR in Excel is a pre-defined functions IF ERROR Function is placed under the category of logical function in Excel. IF ERROR FUNCTION is used to display the correct result or message in response to the error of a FUNCTION. IF ERROR Function in Excel […]

FV, one of the financial functions which is calculates the future value of an investment based on a constant interest rate. You can use the FV function to get the future value of an investment assuming periodic, constant payments with a constant interest rate. Syntax =FV(rate, nper, pmt, [pv], [type])   Arguments rate – The

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