Hi,
just a quick suggestion: It would be nice if both logic functions could either have an extended syntax, or if there could be added functions to do the following.
Using iserror / isempty to avoid errors, this results more often than not in something like this:
if(
iserror(rather-long-expression-that-might-run-into-an-error-you-get-the-message),
alternative-value-in-case-of-error,
rather-long-expression-that-might-run-into-an-error-you-get-the-message
)
Which is rather clumsy when you have to maintain rather-long-expression-that-might-run-into-an-error-you-get-the-message twice every thime you change something.
Suggested functionality: Either make both behave like IFempty / IFerror when a second parameter is given, or add explicit ifempty / iferror functions:
i[s|f]error(
rather-long-expression-that-might-run-into-an-error-you-get-the-message,
alternative-value-in-case-of-error
)
