Hi Fluff , Alex ...
Sorry to reignite the thread , but i have another DIV issued i hope you can assist with .
The cells all refer to numbers.
Returns DIV error , but what i would really like is " - " .
Driving me mad this one !!!
Fluff's solution was addressing the root cause of the issue. Using IFError effectively ignores the root cause and just replaces the error with an alternate return value.
So if you are ok with that then this should do what you want.