Progression through If / ElseIF messing up on certain records -

[CRIMEDOG]

I am desperate.
Look at this:

Please Login or Register  to view this content.

Listcost = 10650 Repcost = 3034 Range("Rate") =.43 specost=0
I set all 3 as
DIM ... As String
It should evaluate the ElseIf statement as True and input the value - It skips to the Else statement

I know that it has the right figures because I modified the Else statement to be = to each variable

if the ListCost is below 10000 it works right
However - I have other lines where the Listcost is above 10000 and it works

[stnkynts]

DIM ... As String

A string isn't a number. You cannot do math on a string. Try Dim as Double

There may be more issues since this is not your entire code.

[CRIMEDOG]

That was it - what is the limitation on the Double Can it handle decimals?

Thanks!! Don't know why it was working on most - it appears to be working right now.

[stnkynts]

Double can handle decimals which is why I suggested it. If no decimals are involved it is less memory to use "Long" or possibly "Integer" depending on your needs. Glad it worked for you.