#NUM! error return blank instead

[ronie85]

I am receiving a #NUM! error. From T2:T39 I have a formula inserted. T2:T5 is showing numbers as numbers are available in working out the formula, T6:T39 is showing #NUM! as there are no numbers available in the formula.

Is there a formula I can create under this, T40:T77 that returns the same results as T2:T39, but when it comes to the #NUM! error, returns a blank instead?

 

[Snakehips]

ronie85,

If I am understanding correctly then there are two possibilities..

If you are using Excel 2007 upwards then look to use IFERROR() function....

e.g. I =FERROR('your current formula here ', "")

Or if earlier Excel version you need to construct an IF statement using ISERROR()....

=IF(ISERROR('your current formula here'),"",'your current formula here')

NB 'your current formula here' is your current formula without it's current leading = sign

Hope that helps.

 

[ronie85]

Thanks, I solved it myself earlier on using formula =IF(ISERROR(EI78),"",EI78)