If you have to divide figures in one column by figures in another column, you may not want the error message #DIV/0 to appear if one of the figures in a second column is a zero. Or, if you are using VLOOKUP, you may not want #N/A to appear if what you are looking up does not appear in your data table.
I will demonstrate first of all with a division, then with a VLOOKUP.
Select the cell for the first of your division calculations.
Type in an equals sign as all formulae and functions start with an equals sign.
Now type IFERROR followed by an opening bracket (; now type in the formula to be checked, then type a comma, then your required result if there would be an error, followed by a closing bracket. Then click the tick to the left of the formula bar or press…
View original post 200 more words