syntax error using if then condition1 and condition2

[greegan]

I'm getting a syntax error for the first line of the following

If A1 > 17493 and <= 29805.50 Then
S = Application.Min(T4, ((A1 - 17493) * 0.032))

I don't understand why this is occurring.

-- g

 

[VoG]

Try

If Range("A1").Value > 17493 And Range("A1").Value <= 29805.5 Then
    s = Application.Min(Range("T4").Value, ((Range("A1").Value - 17493) * 0.032))

 

[greegan]

That was fast. Thank you.
I should have identified this as vba code and A1 is Public as Currency. So is S and T4.

-- g

 

[VoG]

In that case

If A1 > 17493 And A1 <= 29805.5 Then
    s = Application.Min(T4, ((A1 - 17493) * 0.032))

I would avoid using variable names that look like cell addresses - very confusing.

 

[greegan]

In that case

If A1 > 17493 And A1 <= 29805.5 Then
    s = Application.Min(T4, ((A1 - 17493) * 0.032))

I would avoid using variable names that look like cell addresses - very confusing.

Thank you again. That should have been obvious :P
With the work that I'm doing, there are about 50 variables of which this had to be done. Working with the document these factors are originating, it would be even more confusing to use anything else, unfortunately.


Thank you for the help


-- g