Solved

# I need to update the following formula

Posted on 2013-11-04
249 Views
OK....maybe an easy one. I can't get it to work the way I want to.

I need to update the following formula: =IFERROR(('Projects'!M10),"")

In a workbook, I am referencing a different sheet that has all of the formulas and links in to to another sheet.

I need the formula to return a blank if there is a "0" (zero) and or an error in the field. What's happening now, is its showing a zero in the field and it just needs to be blank.
0
Question by:wrt1mea

LVL 43

Expert Comment

Try

=IFERROR(1/(1/(Projects!M10)),"")
0

LVL 2

Accepted Solution

kerick earned 500 total points
If you don't ever want to see zero's you can turn off zeros in excel options.
in excel 2013
file:options:advanced: uncheck show a zero in cells that have a zero value
0

LVL 50

Expert Comment

Try this version

=IFERROR(IF('Projects'!M10=0,""),"")

regards, barry
0

LVL 1

Author Closing Comment

Great idea! I didnt know there was an option for that. I guess you learn something everyday.

Thanks again!
0

## Featured Post

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as t…
This code takes an Excel list of URL’s and adds a header titled “URL List”. It then searches through all URL’s in column “A”, looking for duplicates. When a duplicate is found, it is moved to the top of the list. The duplicate URL’s are then highlig…
Graphs within dashboards are meant to be dynamic, representing data from a period of time that will change each time the dashboard is updated with new data. Rather than update each graph to point to a different set within a static set of data, t…
This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.