Manuals/calci/CALCITOCHECK

1) ROWS function To check/Add functionality:-

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

e.g. ROWS({1,2;3,4;5,6}) should return number of rows as '3' (instead of #NULL).

2)PRODUCT function To check/Add functionality:-

• If the cells in calci have numerical as well as text and empty cells, PRODUCT function assigns '0' to text and empty cells.

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

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