diff options
Diffstat (limited to '')
-rw-r--r-- | test/04-function-islogical.txt | 64 |
1 files changed, 64 insertions, 0 deletions
diff --git a/test/04-function-islogical.txt b/test/04-function-islogical.txt new file mode 100644 index 0000000..2673409 --- /dev/null +++ b/test/04-function-islogical.txt @@ -0,0 +1,64 @@ +%% All values in column A are expected to be logical. +%% All values in column B are expected to be non-logical. +%mode init +A1:true +A2:false +A3=ISBLANK(A1) +A4=ISERROR(A2) +A5=ISEVEN(A1) +A6=ISODD(A1) +A7=ISFORMULA(A2) +A8=ISNUMBER(A1) +A9=ISREF(A1) +A10=ISTEXT(A3) +A11=ISNONTEXT(A3) +A12=A1 +A13=A2 +%% B1 is empty +B2:12.4 +B3@string value +B4=1/2 +C1=ISLOGICAL(A1) +C2=ISLOGICAL(A2) +C3=ISLOGICAL(A3) +C4=ISLOGICAL(A4) +C5=ISLOGICAL(A5) +C6=ISLOGICAL(A6) +C7=ISLOGICAL(A7) +C8=ISLOGICAL(A8) +C9=ISLOGICAL(A9) +C10=ISLOGICAL(A10) +C11=ISLOGICAL(A11) +C12=ISLOGICAL(A12) +C13=ISLOGICAL(A13) +C43=ISLOGICAL(1) +C44=ISLOGICAL("string value") +C45=ISLOGICAL(A100) +C46=ISLOGICAL(C1) +D1=ISLOGICAL(B1) +D2=ISLOGICAL(B2) +D3=ISLOGICAL(B3) +D4=ISLOGICAL(B4) +%calc +%mode result +C1=true +C2=true +C3=true +C4=true +C5=true +C6=true +C7=true +C8=true +C9=true +C10=true +C11=true +C12=true +C13=true +C43=false +C44=false +C45=false +C46=true +D1=false +D2=false +D3=false +%check |