Nearly every Excel formula of Invantive Control for Excel carries `executionHint` as its last parameter. It is optional and empty by default, in which case no hint applies. The parameter influences how the formula is executed; it never influences which value is retrieved. A value is a list of hints separated by a comma, without spaces, written in capitals. The following hints are available: - `ALL_ROWS`: retrieve all rows rather than stopping as soon as enough rows are available. - `SHOWPROGRESS`: inform the user about the progress of the execution in a window. - `VERBOSENA`: return the reason behind an `#N/A` result instead of the plain error value. - `VERBOSEERR`: return the reason behind an error result instead of the plain error value. - `VERBOSE`: both `VERBOSENA` and `VERBOSEERR`. - `ASYNC`: accepted, with no effect at present. A value which is not one of these is rejected with message `itgenuee001`, which names the hints allowed. The hints are those of Invantive Control for Excel and are a set of their own; the hints of [[Invantive UniversalSQL/Execution Hints/Execution Hints|Invantive UniversalSQL]] are not accepted here. `VERBOSENA`, `VERBOSEERR` and `VERBOSE` are meant for finding out why a formula does not return the expected value: instead of the bare Excel error value the cell then shows what led to it. They are not meant for a model in production, since the text takes the place of the value a calculation would use. ## Examples The following example retrieves the name of the Nmbrs debtor and, where that fails, the reason instead of `#N/A`: ``` I_NMBRS_DEBTOR_NAME("VERBOSENA") ``` The following example retrieves the company number of the current Nmbrs company, retrieving all rows and showing the progress: ``` I_NMBRS_COMPANY_NUMBER("";"ALL_ROWS,SHOWPROGRESS") ```