Hi everybody,
I have a formula that sometimes returns '# REF!'. I want to catch these errors and replace the string '# REF!' with a default value (eg -1). How can I do?
Thanks in advance
Hi everybody,
I have a formula that sometimes returns '# REF!'. I want to catch these errors and replace the string '# REF!' with a default value (eg -1). How can I do?
Thanks in advance
Hi
Try surrounding your formula with iferror(your formula),"") put what you need between the quotes.
Chris
Click my star if I helped Thanks
Perfect! thanks.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks