close
Hi
In VBA I set
X = (Jlt;15)*8
where J=10, so the statement is true, but quot;Xquot; is set = to quot;-8quot;
if True = 1 why is the 8 negative?
Hi,
Because TRUE, in this case, equates to -1
Try this in the immediate window.
?int((10lt;15))
Cheers
Andy
Jeff wrote:
gt; Hi
gt;
gt; In VBA I set
gt;
gt; X = (Jlt;15)*8
gt;
gt; where J=10, so the statement is true, but quot;Xquot; is set = to quot;-8quot;
gt; if True = 1 why is the 8 negative?
--
Andy Pope, Microsoft MVP - Excel
www.andypope.info
全站熱搜
留言列表
