I need to update the following formula

OK....maybe an easy one. I can't get it to work the way I want to.

I need to update the following formula: =IFERROR(('Projects'!M10),"")

In a workbook, I am referencing a different sheet that has all of the formulas and links in to to another sheet.

I need the formula to return a blank if there is a "0" (zero) and or an error in the field. What's happening now, is its showing a zero in the field and it just needs to be blank.
LVL 1
wrt1meaAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
kerickConnect With a Mentor Commented:
If you don't ever want to see zero's you can turn off zeros in excel options.
in excel 2013
file:options:advanced: uncheck show a zero in cells that have a zero value
0
 
Saqib Husain, SyedEngineerCommented:
Try

=IFERROR(1/(1/(Projects!M10)),"")
0
 
barry houdiniCommented:
Try this version

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

regards, barry
0
 
wrt1meaAuthor Commented:
Great idea! I didnt know there was an option for that. I guess you learn something everyday.

Thanks again!
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.