In Excel, I have a long, complex expression (Expression A) that I am using in a formula. I want this formula to return the value of Expression A except in the case where that expression is equal to some specific value (0 for example), in which case it returns something else, like "(none)".
Is there a way of writing
=IF(<Expression A> = 0, "(none)", <Expression A>) that wouldn't require me to repeat the entirety of Expression A twice? (Sort of like how
IFERROR works, except with a custom condition)