UDF Division Problem what operator?

I have broken my big User Defined Function down into parts to see where the mishap is...

Here is what I have found:

Please Login or Register  to view this content.

The facter is.58 and the Listcost is 4888, so the result should be: 8,427.58 - what it is giving is: 4888.

Can anyone see what is amiss?

Why did that work? Because of the Division?

Integer data types can only store integers. 0.58 is not an integer, so when VBA stores 0.58 in an integer variable, it rounds it to the nearest integer (1 in this case). 4888/1=4888

Double is the data type that is meant to be used when storing and doing math on non-integer numbers.

What happened is that when .58 was passed to your function Lcost it rounded .58 to the nearest whole number (integer) so that 4888 / 1 = 4888. If facter was .48, you would have gotten a divide by zero error, because the nearest whole number to .48 is zero.

Gotcha - It is now working for 98% of the lines in my sheet, some return Number errors and some return value errors - everything else is right. I am going through trying to evaluate the difference. Thanks for all the help guys. I love this forum.