[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 192
  • Last Modified:

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.
0
wrt1mea
Asked:
wrt1mea
1 Solution
 
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
 
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
Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
Saqib Husain, SyedEngineerCommented:
Ok lets see how this one behaves

=IFERROR(IF(SUM(--(Projects!M10={0,"0"})),"",Projects!M10),"")
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

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now