If you have a calculation that results in an error like, #N/A, #VALUE!, #REF!, #DIV/0!, #NUM!, #NAME?, then you can clean it up by using the IFERROR function which allows you to replace the error it with a 0 or a blank cell.

I show you both IFERROR examples below.

DOWNLOAD WORKBOOK

IfError

Helpful Resource:

excel-formula-crash-course-from-chandoo.org

If you like this Excel tip, please share itEmail this to someone

email

Pin on Pinterest

Share on Facebook

Tweet about this on Twitter

Share on LinkedIn

Share on Google+

Related Posts

WEEKDAY function: Introduction The WEEKDAY function returns the day of the week corresponding to a date.  The day is given as an integer, ranging from 1 (Sunday) to 7 (Saturday).So if you want to find out on what day you were born, then the WEEKDAY function will remind you.DOWNLOAD WORKBOOKHelp...
INDIRECT Function in Excel What does it do?Returns a reference to a range. The referenced range can be a cell, a range of cells, or a named range.Formula breakdown:=INDIRECT(ref_text, )What it means:=INDIRECT(Return the referenced range, Omit if the reference is an A1 style or enter FAL...
Sum the Last 7 Transactions with the Offset Functi... What does it do?It returns a reference to a range, from a starting point to a specified number of rows, columns, height and width of cellsFormula breakdown:=OFFSET(reference, rows, columns, , )What it means:=OFFSET(start in this cell, go up/down a number of ro...
INDIRECT Function Using Sheet References What does it do?Returns a reference to a cell, or a range of cells of a sheet.Formula breakdown:=INDIRECT(ref_text, )What it means:=INDIRECT(Return the referenced range, Omit if the reference is an A1 style or enter FALSE if it is a R1C1 style)The ...