Excel - Double Negatives (Past, Present and Future)
Hi Dennis
I agree with you that the usage of '--' as a replacement for '+' is no
good programming style. But the double unary operator has it's usage
(see my other post)
--
Regards
Frank Kabel
Frankfurt, Germany
DennisE wrote:
As far as I can tell, Excel invariably compiles a double minus sign
as a plus sign (and a triple minus sign as a minus, etc.). Thus if
A1=4 and B1=3, C1=A1--B1 yields 7 and D1=A1---B1 yields 1. Although
there is nothing illegal about it, I would classify doing such things
as being among the poorest programming practices
ever seen. It's no wonder a google search for such things turned up
nothing.
-- Dennis Eisen
|