Solved

I need to update the following formula

Posted on 2013-11-04
4
249 Views
Last Modified: 2013-11-04
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
Comment
Question by:wrt1mea
4 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
Comment Utility
Try

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

Accepted Solution

by:
kerick earned 500 total points
Comment Utility
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

by:barry houdini
Comment Utility
Try this version

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

regards, barry
0
 
LVL 1

Author Closing Comment

by:wrt1mea
Comment Utility
Great idea! I didnt know there was an option for that. I guess you learn something everyday.

Thanks again!
0

Featured Post

What Should I Do With This Threat Intelligence?

Are you wondering if you actually need threat intelligence? The answer is yes. We explain the basics for creating useful threat intelligence.

Join & Write a Comment

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.

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now