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!M1 0)),"") Wipes out any data that was in the field, returns no information.
I need to update =IFERROR(('Projects'!K44),
1. Turned off zeros in excel options
2. =IFERROR(IF('Projects'!M10
3. =IFERROR(1/(1/(Projects!M1
This will take care of 0 entered as text
=IFERROR(IF(VALUE(Projects !M10)=0,"" ,Projects! M10),"")
=IFERROR(IF(VALUE(Projects
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....
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I imagine this will work for text or numbers
=IFERROR(IF('Projects'!M10 ="","",'Pr ojects'!M1 0),"")
regards, barry
=IFERROR(IF('Projects'!M10
regards, barry
ASKER
Works perfectly...
Barry....your version returned the zero...Hope all is well!!!
Barry....your version returned the zero...Hope all is well!!!
pls try
Open in new window
Regards