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

4)HOUR,MINUTE,SECOND function with serial numbers of time as input.

TIMEVALUE("3:30") gives 0.1458333333284827 (which is correct)

If the above serial number is used as input to HOUR, MINUTE and SECOND functions, following are the observations :

• HOUR(0.1458333333284827) displays '19' (Expected Output: '3')
• MINUTE(0.1458333333284827) displays '0' (Expected Output: '30')
• SECOND(0.1458333333284827) displays '0' (correct. But displays '0' for other serial numbers too)

The output is same(i.e. 19,0,0) for any other serial numbers (e.g 0.9479166666642413 for "10:45 PM").