Blank and 0 cells

12.ods (11.9 KB)
Screenshot from 2026-07-06 09-54-01

Why isn’t A4 considered as 0 and how can i solve the issue?
Thank you.

You could enter the formula =IF(A3=0;0;1), which seems to be what you really want but don’t want to see the 0, and then format the column with format code #
12_136160EA.ods (10.5 KB)