| Ev (Textstring_s, [DefaultValue], [Options]) | | BF Indirect function equivalent | | | | Pro | | Auto Multi Function | Values for "Options" (or "Opts") | - 1. Use the DefaultValue if Textstring is an error (eg #NUM!, #NA etc). (Normal behaviour: throw an error)
- 2. Use the DefaultValue if the reference in Textstring is an error or is invalid (ie Textstring was OK, but the thing its pointing at is an error or its an invalid reference). (Normal behaviour: throw an error)
The function will always choose the default if Textstring is missing or blank and a DefaultValue is available.
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 | Example Ev.xls |
Any comments on this documentation? Send us your suggestions below. | 