Why is that, what was wrong with having it as a double?
it is to do with the way doubles are calculated, even 2 doubles that you can see have to be equal, vb may not agree

?cdbl(.14*100)= cdbl(15-1)
False
?(.14*100)-14
1.33226762955019E-15
i am sure that the difference is a very small number (0.0000000000000013322676295502)

there are several way to force significant equality, one way is to limit the number of decimal places using round function, which clng also does (in this case) by removing all decimal places

a single would also work correctly in this particular case