--- Niklas Nebel <[EMAIL PROTECTED]> wrote:
> Sander Vesik wrote:
> > how do I get the value of a cell to be +INF / -INF? the obvious way doesn't
> > work
> :(
>
> 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()
> 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.
> Niklas
Sander
.sigless
___________________________________________________________
Yahoo! Messenger - NEW crystal clear PC to PC calling worldwide with voicemail
http://uk.messenger.yahoo.com
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
