Ignore #VALUE Error

[counihan3]

I am putting several formuals together, I have one formula that is causing the problem. Is there something that I can put infront of the formula such as ISERROR, to keep that value from returning.

 

[Jonmo1]

IF(ISERROR(originalformaul),"",originalformula)

 

[counihan3]

Thanks, i wouldn't have thought about using and if statment to fix it.

 

[priomsrb]

A simpler way would be:

IFERROR(originalformula,"")


PS. Sorry for reviving this old post. But since this was the first result on my google search, I thought it was worth updating.

 

[Robert_G]

I ended up using a helper column but got accomplished what I wanted to. I actually wanted to use the entire number instead of the 4 right digits (as throughout the year the number goes up until 18 becomes 19 at the first of the year). I just used the substitute function (eliminating the hyphen), changed to a VALUE, & then used whatever MAX/MIN function I wanted to & then used a custom format in the number to have it appear back has its original form.