Note: In order to use the spreadsheet examples, you need to download Business Functions
|Ev (Textstring_s, [DefaultValue], [Options])|
|BF Indirect function equivalent|
|Evaluate. Like Excels INDIRECT but it can accept a whole formula (eg MyRangeName*2), not just a reference (eg A23) or a range name (eg MyRangeName). You can also set a default value if the string is a blank or an error.|
Values for "Options" (or "Opts")
These are options are additive eg 1+2 etc.
If you want to use the default under any error BF can detect, set Options to 3
For Excel Experts
Note that, because this function is like INDIRECT(), it also is Volatile, which means that it is always recalculated when the worksheet recalculates, regardless of whether the input the data has changed. This is because Excel has no way of knowing whether the cell ranges that Textstring_s are pointing to have changed.
If Options is not specified or is zero, the function behaves similar to Excel"s INDIRECT() function.
Usually only one Textstring is entered. If you enter more than one (sometimes called Automulti functionaility in the BF documentation), then each Textstring is dealt with in turn, and the results are added together.
Since this functions is like INDIRECT in that it takes a text reference and looks it up, there is a fair chance you will get errors from time to time if you specify a reference that does not exist. If the EV() functions are buried in a long formula and there are lots of them, it can be tricky to find which one is causing the problem. To isolate the problem one, place the cursor of an the EV in the Ev() function you want to examine, and go Alt-I-F. Although this is strictly Insert Function, all it does in this case is bring up Excel"s function wizard so that you can check out the inputs and see what the function evaluates to. If it doesn"t evaluate to anything or it is an error, then you have found the problem.