View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
Frank Kabel Frank Kabel is offline
external usenet poster
 
Posts: 3,885
Default 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