next up previous contents index
Next: CLEAN Up: A Function Reference Previous: CHAR

CHOOSE

 

Syntax: @CHOOSE(N, argumentlist)

N = a numeric value which should be <= the number of items in argumentlist - 1
argumentlist = any combination of numbers, strings, or cell addresses separated by commas.

@CHOOSE returns the Nth argument from the argument list, starting with an index of 0.

Examples:

@CHOOSE(2, D1, C22, F5, K1) = 54, where F5= 54

@CHOOSE(1, A9, D23, G12) = ``Peaches'', where D23 = ``Peaches''

@CHOOSE(3, ``nuts'', ``rings'', ``bolts'', ``fittings'') = ``fittings''

@SUM(@CHOOSE(A1>B1, B1..B10, A1..A10)) sums either column A or column B.


next up previous contents index
Next: CLEAN Up: A Function Reference Previous: CHAR

NExS User's Guide, Version 1.4.5
Grey Trout Software
11 April 1999