Is there a neat way to do IF(ISERROR(a long statement),0,a long statement)?

[excelos]

Hello

Often I write a long statement which I want to prevent it appearing as #N/A, so I do an IF statement like: IF(ISERROR(a long statement),0,a long statement)

The problem is that with the above, I have to repeat the long statement twice which makes the formula very long and difficult to read.

Is there a neater way to do that? Maybe store the statement in a variable and use that variable in the IF statement or is there an alternative formula that I can use?

Thanks!

 

[Fluff]

You can use IFERROR or IFNA instead.