Forum Discussion
Increase size of Evaluate Formula Dialog Box
Hi mathetes, thanks for suggestion. I have tried breaking this into several steps using the intermediate "helper" formulas, but the current small sized "Evaluate Formula" dialogue box still doesn't prove to be very easy to use.
Aside, having nothing to do with the size of the Evaluate Formula dialog box....
Instead of the form
IFNA(IFS(condition1, result1, ..., conditionN, resultN), defaultResult)
it would be better to write
IFS(condition1, result1, ..., conditionN, resultN, TRUE, defaultResult)
or
IFS(condition1, result1, ..., TRUE, resultN)
Use the latter form only if resultN is the intended defaultResult.
The point is: it is "good practice" to have a TRUE condition/result pair at the end of IFS expressions to avoid an unintended #N/A error, just as it is "good practice" to have a value-if-false expression at the end of IF expressions to avoid an unintended FALSE result.