Difference between revisions of "Manuals/calci/CALCITOCHECK"
Jump to navigation
Jump to search
| Line 2: | Line 2: | ||
*The function displays #NULL error with arguments as array values. | *The function displays #NULL error with arguments as array values. | ||
| − | e.g. ROWS({1,2;3,4;5,6}) | + | e.g. ROWS({1,2;3,4;5,6}) |
| + | |||
Expected result: ''3'' | Expected result: ''3'' | ||
| + | |||
Observed result: ''#NULL'' | Observed result: ''#NULL'' | ||
| Line 10: | Line 12: | ||
*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). | *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 | e.g. PRODUCT(A1:A5) returns '0' where A1=2,A2=4,A3=TEXT,A4= ,A5=1 | ||
| + | |||
Expected result: ''8'' | Expected result: ''8'' | ||
| + | |||
Observed result: ''0'' | Observed result: ''0'' | ||
*Function works correctly with logical values. i.e. assigns TRUE=1, FALSE=0 | *Function works correctly with logical values. i.e. assigns TRUE=1, FALSE=0 | ||
Revision as of 15:39, 13 December 2013
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