I need to update the following formula

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.
LVL 1
wrt1meaAsked:
Who is Participating?
 
Saqib Husain, SyedConnect With a Mentor EngineerCommented:
Ok lets see how this one behaves

=IFERROR(IF(SUM(--(Projects!M10={0,"0"})),"",Projects!M10),"")
0
 
Rgonzo1971Commented:
Hi,

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

Open in new window

Regards
0
 
Saqib Husain, SyedEngineerCommented:
This will take care of 0 entered as text

=IFERROR(IF(VALUE(Projects!M10)=0,"",Projects!M10),"")
0
Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

 
wrt1meaAuthor Commented:
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
 
barry houdiniCommented:
I imagine this will work for text or numbers

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

regards, barry
0
 
wrt1meaAuthor Commented:
Works perfectly...

Barry....your version returned the zero...Hope all is well!!!
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.