Difference between revisions of "Manuals/calci/CALCITOCHECK"
Jump to navigation
Jump to search
(Created page with "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...") |
|||
| Line 1: | Line 1: | ||
1) '''ROWS''' function | 1) '''ROWS''' function | ||
| − | + | ||
*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'' | ||
| + | Observed result: ''#NULL'' | ||
| + | |||
2)'''PRODUCT''' function | 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). | |
| − | *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 | 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 | *Function works correctly with logical values. i.e. assigns TRUE=1, FALSE=0 | ||
Revision as of 15:38, 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