Link to home
Start Free TrialLog in
Avatar of wrt1mea
wrt1mea

asked on

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.
Avatar of Rgonzo1971
Rgonzo1971

Hi,

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

Open in new window

Regards
This will take care of 0 entered as text

=IFERROR(IF(VALUE(Projects!M10)=0,"",Projects!M10),"")
Avatar of wrt1mea

ASKER

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....
ASKER CERTIFIED SOLUTION
Avatar of Saqib Husain
Saqib Husain
Flag of Pakistan image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
I imagine this will work for text or numbers

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

regards, barry
Avatar of wrt1mea

ASKER

Works perfectly...

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