Hide Error

Dan Crimmins

Hi,

I have a sheet with a couple of big weighty formulas. Sometimes the cells containing the formulas are not required to be used in the row and criteria might be missing in the row and so the error #INVALID VALUE appears as expected.

How can I hide this error from the sheet as it shows up on reports and makes them look bad. I have seen there is an IFERROR function however my formula is already so long I am concerned about getting it in there and was wondering if there is a simpler solution

Thanks

Dan

Andrée Starå

Hi @Dan Crimmins

I hope you're well and safe!

I'd recommend using the IFERROR feature or add a check in the formula.

There is a limit of 4000 characters, so you're probably ok.

Would that work/help?

I hope that helps!

Be safe and have a fantastic week!

Best,

Andrée Starå | Workflow Consultant / CEO @ WORK BOLD

✅Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

Dan Crimmins

Hi Andrée

Thanks for the clarification I will see how I can incorporate the IFERROR