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


pls try

Open in new window

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

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:

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.


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


regards, barry
wrt1meaAuthor Commented:
Works perfectly...

Barry....your version returned the zero...Hope all is well!!!
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.