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.