View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Rob van Gelder[_4_] Rob van Gelder[_4_] is offline
external usenet poster
 
Posts: 1,236
Default What is the difference between "=if" and "=+if"??

Wendy,

The plus sign in this context is redundant. It tells us that the result is
positive.
If the plus were a minus sign instead, it would tell us that the result is
negative.

As Hank pointed out, it's probably left over from a data entry shortcut.


The + here is a unary operator. To learn more about unary operators:
http://www.google.com/search?q=define:Unary+Operator

Rob



"Wendy" wrote in message
...
May I know what is the difference between the formula start with "=if" and

"=+if"?? Is it a new feature?

Thanks!

Wendy