ExcelBanter - error -1.#IND

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

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - error -1.#IND (https://www.excelbanter.com/excel-programming/441193-error-1-ind.html)

Adax[_4_]

error -1.#IND

Hello, one of number has i VBA code value -1.#IND. What mean it?

Martin Brown

error -1.#IND

Adax wrote:
Hello, one of number has i VBA code value -1.#IND. What mean it?

Indeterminate.

Result cannot be represented in a floating point register.
Most likely the result of 0/0, sqrt(-1) or similar.

Regards,
Martin Brown

All times are GMT +1. The time now is 06:51 AM.