# My simple formulas no longer give blank cells [closed]

I have used simple formulas like =IF(B10>0,+B10-B9,"") for years and have always returned a blank cell. Worked fine in Libreoffice until a recent update and now it will not return a blank cell, instead it returns zeros. I see where I can turn off " show zero values" but then I can't have other cells where I want to display zero as a value. Is there a way to return to showing a blank cell instead of zeros while retaining the ability to display zeros where I choose?

Added comment:Using windows 8.1 and Libre Version: 4.1.4.2 Build ID: 0a0440ccc0227ad9829de5f46be37cfb6edcf72

Please what is your Operating System and the LibreOffice version?, I can't reproduce your issue.

Is there a decimal issue? In your cell that shows zero, can you add more decimals. I put 0.0001 in both B9 and B10, then changed C10 to display no decimals which resulted in a zero value? This doesn't explain why it would suddenly change though.

amusing this formula ...=IF(B10>0,+B10-B9,"")...is in cell B11... If B10 is blank then B11 has 0.00 in it,if I put a zero in B10 then B11 goes blank.

Also if I use Ctrl drag to copy the formula to adjacent cells in column the zeros go away.

BUT when I close the doc and then reopen it the zeros have returned .

These spread sheets work normally with these exact formulas for well over a year.