ExcelBanter - How to return 1 with #VALUE!?

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - How to return 1 with #VALUE!? (https://www.excelbanter.com/excel-worksheet-functions/127036-how-return-1-value.html)

Eric

How to return 1 with #VALUE!?

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

JE McGimpsey

How to return 1 with #VALUE!?

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

Dave Peterson

How to return 1 with #VALUE!?

Check your other post.

Eric wrote:

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

--

Dave Peterson

Teethless mama

How to return 1 with #VALUE!?

=IF(ISERROR(your formula),1,your formula)

"Eric" wrote:

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

Eric

Thank everyone for suggestion

Thank everyone for suggestion

All times are GMT +1. The time now is 10:08 AM.