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!
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!