Sander Vesik wrote:
Infinity isn't supposed to be in a cell. An infinite result from a
formula is considered an error, and the error message (Err:503) is
shown. Issue 47724 exists to distinguish between different errors, but
it would still be an error flag, not infinity value.
So I can't do it directly and even writing a function add-in function like
plusinf()
Right. The add-in function's result would be recognized as an error.
That said, you can "sneak in" infinity through API calls that expect a
value, but it's certainly not recommended - don't rely on any further
operations on such a cell to still work.
What are you trying to achieve?
A cell having a value x such that 1/x would be zero - and in the process save me
having to write complex formulas with large number of IF()-s.
I see. 1/x would even (happen to) work once you have infinity in a cell,
because it's the results that are checked, not the input values. But
even a simple reference, like =A1 for example, would show an error,
seeing infinity as an indication that the "calculation" could not be
carried out.
To change this, lots of places would have to be modified (and, in the
first place, have a definition how to react on infinity values).
Niklas
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
