# Multiple sheets on LibreOffice Calc [closed]

Hello, i have a minor problem while working on LibreOffice Calc. I will explain the whole thing so you can understand me (English is not my mother tongue). On the first sheet i am writing the Invoice, and on the second shit is another document. Everything is okay when i have invoice with one article, i type the formula "=$sheet1.d15" for example, and on the second sheet above that i type the next column/row, but if in the invoice is empty i get 0? So my question is can i write on the second sheet for example "=$sheet1.d15", then above "=$sheet1.d16" et cetera but if on sheet1 D16 is empty to avoid getting 0 on sheet2? Thanks in advance!

Heading of this question is misleading. The issue is about not showing zero values as formula results, no matter you put it in the same sheet or in another.