Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people, just like you, are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
Solved

I need to update the following formula

Posted on 2013-11-06
6
186 Views
Last Modified: 2013-11-06
I posted this question yesterday and thought it was answered correctly. In some cases, there are still zeroes being displayed.

I need to update =IFERROR(('Projects'!K44),"") to return a blank if there is a value of Zero in the sheet it is linked to. I have tried the following with no luck:

1. Turned off zeros in excel options
2. =IFERROR(IF('Projects'!M10=0,""),"") RETURNS FALSE
3. =IFERROR(1/(1/(Projects!M10)),"") Wipes out any data that was in the field, returns no information.
0
Comment
Question by:wrt1mea
6 Comments
 
LVL 50

Expert Comment

by:Rgonzo1971
ID: 39627439
Hi,

pls try
=IFERROR(IF(Projects!M10=0,"",Projects!M10),"")

Open in new window

Regards
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39627625
This will take care of 0 entered as text

=IFERROR(IF(VALUE(Projects!M10)=0,"",Projects!M10),"")
0
 
LVL 1

Author Comment

by:wrt1mea
ID: 39627840
Rgonzo1971...

I tried your formula and it did not remove the zeroes....FYI, these are referencing text.  The other cells where I am referencing number values, I have no problems.

Ssaqibhy...

I tried your formula and it completely wiped out all of the text. Most of the information I am referencing is text. No issues with referencing numbers....
0
Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

 
LVL 43

Accepted Solution

by:
Saqib Husain, Syed earned 500 total points
ID: 39627928
Ok lets see how this one behaves

=IFERROR(IF(SUM(--(Projects!M10={0,"0"})),"",Projects!M10),"")
0
 
LVL 50

Expert Comment

by:barry houdini
ID: 39628231
I imagine this will work for text or numbers

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

regards, barry
0
 
LVL 1

Author Closing Comment

by:wrt1mea
ID: 39628312
Works perfectly...

Barry....your version returned the zero...Hope all is well!!!
0

Featured Post

Free Tool: Port Scanner

Check which ports are open to the outside world. Helps make sure that your firewall rules are working as intended.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction This Article is a follow-up to my Mappit! Addin Article (http://www.experts-exchange.com/A_2613.html), it was inspired by an email posting I made to EUSPRIG (http://www.eusprig.org/index.htm), I will briefly cover: 1) An overvieā€¦
Do you use a spreadsheet like Microsoft's Excel?  Have you ever wanted to link out to a non excel file on your computer or network drive?  This is the way I found to do it!
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

792 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