How about 'IF(x=2,0,5)' ?
On Apr 25, 2007, at 13:48 , Marc Weber wrote:
Is the cell evaluation engine one? I think not. I do not
believe what
you can type into those cells does constitute a programming
language,
or at least not a turing complete one. As far as i know only
simple
calculations can be performed. For example, is there any way to
evaluate f(2) = 0, f(x) = 5
Sure. Should not be hard using 5 - 5 * (1-abs(sign(2-x)))
I admit that I didn't test it using Excel but oocalc.
Or is this VBA?
You are right. I get your intention ;)
Marc
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe
_______________________________________________
Haskell-Cafe mailing list
Haskell-Cafe@haskell.org
http://www.haskell.org/mailman/listinfo/haskell-cafe