E
Eric
Does anyone know how to return 1 with #VALUE!?
Thank for any suggestion
Eric
Thank for any suggestion
Eric
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
J
JE McGimpsey
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.
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.
D
Dave Peterson
Check your other post.
Does anyone know how to return 1 with #VALUE!?
Thank for any suggestion
Eric
T
Teethless mama
=IF(ISERROR(your formula),1,your formula)
E
Eric
Thank everyone for suggestion