UserFunc UserFunc is an External Tool containing five External Functions. This file is an example demonstrating the use of External Functions in Wingz. To use the UserFunc tool, execute the following command: GET EXTERNAL "UserFunc" If UserFunc is not located in your current directory, you must specify the full path in front of the file name in the string expression. You can enter any of the External Functions into your worksheet, or use the HyperScript CALL command. The functions available within UserFunc are listed below: Fact(argument) This function returns the factorial of the supplied argument. The argument must be a positive number. If the supplied argument is a string or a negative number, the function returns ERR 12. For example, the formula =UserFunc:Fact(5) returns the value 120. The formula =UserFunc:Fact("Hello") returns ERR 12. MultOrCat(argument1,argument2) This function multiplies two numbers or concatenates two strings. If both argument1 and argument2 are numeric, the result is argument1 multiplied by argument2. If both arguments are strings, the result is the concatenation of argument1 & argument2. Any other combination of arguments is invalid and returns ERR 12. For example, the formula =UserFunc:MultOrCat(5,6) returns 30, the formula =UserFunc:MultOrCat("This ","and That") returns "This and That," and the formula =UserFunc:MultOrCat("Hello",5) returns ERR 12. AddCat3(argument1,argument2,argument3) This function adds three numeric arguments or concatenates three strings. If arguments 1 through 3 are numeric, the result is argument1 + argument2 + argument3. If arguments 1 through 3 are strings, the result is the concatenation of argument1 & argument2 & argument3. Any other combination of arguments is invalid, and returns ERR 12. For example, the formula =UserFunc:AddCat3(10,10,10) returns 30, the formula =UserFunc:AddCat3("That's ","the ","way") returns "That's the way," and the formula =UserFunc:AddCat3("Seven",8,"Nine") returns ERR 12. MyIncr(argument) This function increments the numeric argument by 1 (by adding a positive 1 to the argument). If a string is used as the argument, the function returns ERR 12. For example, the formula =UserFunc:MyIncr(5) returns 6, the formula =UserFunc:MyIncr(-9) returns -8, and the formula =UserFunc:MyIncr("Hello") returns ERR 12. AddCat5(argument1,argument2,argument3,argument4,argument5) This function adds five numeric arguments or concatenates five strings. If arguments 1 through 5 are numeric, the result is argument1 + argument2 + argument3 + argument4 + argument5. If arguments 1 through 5 are strings, the result is the concatenation of argument1 & argument2 & argument3 & argument4 & argument5. Any other combination of arguments is invalid and returns ERR 12. For example, the formula =UserFunc:AddCat5(10,10,10,10,10) returns 50, the formula =UserFunc:AddCat5("That's ","the ","way ","I ","like it") returns "That's the way I like it," and the formula =UserFunc:AddCat5(6," seven ","eight ",9," and ten") returns ERR 12. { Version info: @(#)FUNC.README 2.1.2.1 95/05/11 }