I am trying to compute a varaible through the following formula:
dim avg as integer
dim test as integer
test = 1
avg = (test = 1)* 4
Debug.Print avg
it gives me -4 instead of 4. My test condition (test = 1) should return me 1 and my average should be 4 instead of
-4.
Any ideas why it's doing this? Thanks a lot for your help.
Jay
dim avg as integer
dim test as integer
test = 1
avg = (test = 1)* 4
Debug.Print avg
it gives me -4 instead of 4. My test condition (test = 1) should return me 1 and my average should be 4 instead of
-4.
Any ideas why it's doing this? Thanks a lot for your help.
Jay