See one answer in microsoft.public.excel.misc

Please don't post the same message to multiple groups. It just tends to
fragment any answers, and it potentially wastes the time of those
answering questions that have already been answered.


In article ,
Eric wrote:

Does anyone know how to return 1 with #VALUE!?
Thank for any suggestion
Eric