 # LibreOffice Calc 0 > 0 returns true?

trying to create a formula where it calcs if two things are greater then 0 however if any of them are 0 it returns true. the fields are whole numbers filter only and the formula works perfectly if the fields are empty but not if they are ‘0’.

my formula is “=IF( AND(EC2>0,N36>0), 3, 0)”
EC2 is ‘0’ whole number filter.
N36 is ‘0’ whole number filter.
it is posting ‘3’ as if true.

if EC2 and N36 is empty instead of ‘0’ it posts ‘0’ as wanted.

EDIT:
LibreOffice version 5.4.4.2, Windows 10 64bit.
(it is cell R36 with reference to EC2 which is not working. if EC2 is empty it works, if it is a zero it doesn’t

Also side question, how do i add more then one tag? doesn’t accept ‘,’ or ’ ’ as delimiters Mention your LO version, OS, and also please provide an example file with the issue (post a link to a share where you put the file).

`="0">0` should return TRUE
`=0>="0"` should return FALSE
Check the type of your operands.
`=0>0` will surely return FALSE if entered exactly this way. If one or both of the zeros here are in fact references you expect a zero returned for, the result is a question of the types returned.
`="0">123` will also return TRUE.

Since the linked cell should be a helper anyway (and actually is in the given example) the solution is trivial: Simply use an additional helper. In the given case columns DS and EC contain the linked helpers. Columns DT and ED are empty. Put `=0+DS2` into DT2 and `=0+EC2` into ED2, fill the formulae down as far as needed, and refer to DT or ED where you intended to refer to DS and EC respectively. The arithmetic expression with its leading number will cause an automatic conversion to number for the second operand. To do it more cleanly I would prefer to use the VALUE() function: `=VALUE(DS2)` e.g.
I don’t know if you can make checkboxes set numbers instead of text. But you could use a formula like `=IF(VALUE(EC2)>0; 3; 0)`.