Hi,

i have the same formula used in 2 cells:

Screenshot_11.png

Screenshot_13.png

the source table has empty fields so result should be the same but in the first example 0 is on the left (as text) and in the second is on the right as number.
The cell format is the same - general.

How this is working and why?
I would like to pre-empt questions about attaching workbook.

i can not share because i have fragile data and unfortunately i can not even reproduce errror (in new workbook i have 0 on right).

Why this is happening?
Did you have any similar issues?

Best,
Jacek