Special Function Handling - IF, IFS, CHOOSE, SWITCH

Conditional Functions – IF, IFS, CHOOSE, SWITCH

Explorer Pro will indicate the correct result expression of conditional functions by using bold text on a green background in both the Expression and Source/Result boxes.

To distinguish number that are Text from real numbers, text numbers are shown in quotes.

E format number results are shown enclosed in ( ) to distinguish them from expressions.

Volatile Functions

Volatile functions will be shown in yellow.
The Source/Reference box show the source that the INDIRECT is pulling from a 4 row by 3 column range J22:L25, and for the C5 reference shows the content of the cell C5.

Indirect Array Formula Example

This example shows INDIRECT being used in an array formula.

The indented formula box shows the formula enclosed in { } because it is an array formula.

The precedents of INDIRECT are shown in the Source/Results box.

The Color/Results button has been toggled ON, so

The results of the INDIRECT are shown in the results box and could be filtered.

The Source precedents of the INDIRECT are selected and colored on the worksheet.

User-Defined Functions

UDFs are shown in Italics and colored yellow when Explorer Pro cannot determine if they are volatile.

For VBA UDFs the tooltip indicates that the UDF may be Volatile and is single-threaded

Copyright © 2020 Decision Models Ltd