EVALCELL Function
Takes a reference to a cell that contains a custom function as well as one or more name-value pairs to pass to the custom function as arguments (optional). Returns the calculated result of the custom function given the specified arguments and values.
Syntax
EVALCELL(cellRef,[ arg1Name,arg1 ],[ arg2Name,arg2 ],…)
Parameters
| Name | Required/Optional | Data Type | Description |
|---|---|---|---|
| cellRef |
Required |
String |
A reference to the cell that contains the custom function. Cross-sheet references are allowed. |
| arg1Name |
Optional |
String |
The name of the first argument to be passed to the custom function. Spaces are allowed. |
| arg1 |
Optional |
Varies |
Value of the arg1 parameter. |
| arg2Name |
Optional |
String |
The name of the second argument to be passed to the custom function. Spaces are allowed. |
| arg2 |
Optional |
Varies |
Value of the arg2 parameter. |
Return value
Number
Remarks
The calling cell does not have to specify every argument used by the custom function.
Example
The following example shows how to use the EVALCELL function in conjunction with the ARG function to find the middle value from a set of three values.
In the expression cell, place the following code that defines the custom function:
User.MiddleValue = IF(ARG("A")>ARG("B"),IF(ARG("B")>ARG("C"),ARG("B"),IF(ARG("A")>ARG("C"),ARG("C"),ARG("A"))),IF(ARG("A")>ARG("C"),ARG("A"),IF(ARG("B")>ARG("C"),ARG("C"),ARG("B"))))
In the calling cells, place the following code that calls the custom function:
User.Middle1 = EVALCELL(User.MiddleValue,"A",3,"B",9,"C",5)
User.Middle2 = EVALCELL(User.MiddleValue,"A",12,"B",0,"C",21)