View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Tim Williams Tim Williams is offline
external usenet poster
 
Posts: 1,588
Default Expression Difference?

What answers do you get, and from what inputs?
They should give the same result, unless perhaps your inputs are of different types and precisions.

Tim.


"FCC" wrote in message ...

Hello,

I was wondering how come these two expression have different results


Code:
--------------------

12 - (previousSickMonth - employmentMonth + tempMonth)

--------------------



Code:
--------------------

12 - previousSickMonth - employmentMonth + tempMonth

--------------------


The first one gives me the correct answer that I want. But it doesn't
make sense to me how come there would be a difference. All the
operators are just subtraction and addition, and it shouldn't be based
on any form of precedence.

Is there some kind of VBA difference from other programming languages I
am missing here?


--
FCC
------------------------------------------------------------------------
FCC's Profile: http://www.excelforum.com/member.php...o&userid=35888
View this thread: http://www.excelforum.com/showthread...hreadid=557981