CODEWITHSUNDEEP
excelexcel-formula
user7675421
user7675421

Reputation: 75

Excel formula returns 0 instead of blank

I am working on an Excel template and when I copy my formula down, it displays 0 instead of being blank. Any suggestions are appreciated. My formula is below:

=IF(ISBLANK('Sheet2'!Y26),"",('Sheet2'!Y26))

Upvotes: 1

Views: 13278

Answers (2)

Oliver Giesen
Oliver Giesen

Reputation: 9459

There is actually an option under File|Options|Advanced|Display options for this worksheet: Show a zero in cells that have zero value.

Simply uncheck that option and the zeros will vanish.

The downside is that this will unconditionally hide all 0 values (except where explicitly returned as a string), so it might not be a feasible solution for all situations.

Upvotes: 6

Abrar E Anjum
Abrar E Anjum

Reputation: 11

Try assigning zero value to ('Sheet2'!Y26) like following: if(('Sheet2'!Y26)=0,"",('Sheet2'!Y26)) because u have formatted that cell as currency, get me back if it works!!

Upvotes: 0

Related Questions