Tag: formula with example in excel

Apr22020 by excelhelp13No Comments

IFERROR With Vlookup

FORMULAS, Logical

IFERROR is used to add a custom remarks or note when no data found or any error occurs for any formula used in excel. Simply you have to add IFERROR before any formula and at the end just add your custom text into double quote and it will not show any #N/A, Error False.

Mar162020 by excelhelp132 Comments

LEFT Function In Excel

FORMULAS, Text

LEFT function is used to extract the specific number of letter or a word from a particular cell. It has only two parameter.First cell reference and second number of character. Left function extract from left starting position. For example "Excel help is a great website" and now if someone need to extract only Excel or Excel help then Left function is the best choice to use it. Example shown below in image and video FORMULA; =LEFT(A2,5)