diff options
Diffstat (limited to 'test/04-function-right.txt')
| -rw-r--r-- | test/04-function-right.txt | 45 |
1 files changed, 45 insertions, 0 deletions
diff --git a/test/04-function-right.txt b/test/04-function-right.txt new file mode 100644 index 0000000..e12cf71 --- /dev/null +++ b/test/04-function-right.txt @@ -0,0 +1,45 @@ +%% Test built-in function RIGHT. +%mode init +A1@ABCDE +A2:12345 +B1=RIGHT(A1) +B2=RIGHT(A1,0) +B3=RIGHT(A1,1) +B4=RIGHT(A1,2) +B5=RIGHT(A1,3) +B6=RIGHT(A1,4) +B7=RIGHT(A1,5) +B8=RIGHT(A1,6) +B9=RIGHT(B8,3) +C1=RIGHT(A2) +C2=RIGHT(A2,0) +C3=RIGHT(A2,1) +C4=RIGHT(A2,2) +C5=RIGHT(A2,3) +C6=RIGHT(A2,4) +C7=RIGHT(A2,5) +C8=RIGHT(A2,6) +C9=RIGHT(C8,2) +D1=RIGHT(A1,-1) +%calc +%mode result +B1="E" +B2="" +B3="E" +B4="DE" +B5="CDE" +B6="BCDE" +B7="ABCDE" +B8="ABCDE" +B9="CDE" +C1="5" +C2="" +C3="5" +C4="45" +C5="345" +C6="2345" +C7="12345" +C8="12345" +C9="45" +D1=#VALUE! +%check |