Manuals/calci/CALCITOCHECK

1) ROWS function

• The function displays #NULL error with arguments as array values.

e.g. ROWS({1,2;3,4;5,6})

Expected result: 3

Observed result: #NULL

2)PRODUCT function

• If the cells in calci have numerical as well as text and empty cells, PRODUCT function assigns '0' to text and empty cells (instead they should be ignored).

e.g. PRODUCT(A1:A5) returns '0' where A1=2,A2=4,A3=TEXT,A4= ,A5=1

Expected result: 8

Observed result: 0

• Function works correctly with logical values. i.e. assigns TRUE=1, FALSE=0

3)OR function

• If the cells in calci have numerical as well as text and empty cells, OR function assigns '0'(FALSE) to text and empty cells (instead they should be ignored).

e.g. OR(TEXT, ) returns FALSE

Expected result: #NULL

Observed result: FALSE