Greater than, less than statement

[Guest]

I have a nested if statement, I am trying to write, if a1 greater than 500
but less than 999, then do X. I can’t seem to get that part to work. Any
Ideas ???
Thanks

 

[Gary Keramidas]

give this a try

Sub test()
Dim ws As Worksheet
Set ws = Worksheets("Sheet1")
If ws.Range("A1") > 500 And ws.Range("A1") < 999 Then
MsgBox "ok"
Else
MsgBox "not ok"
End If
End Sub

 

[Guest]

If x > 500 And x < 999 Then
MsgBox ("IN THERE")
End If

 

[Dave Peterson]

=if(and(a1>500,a1<999),"X","Y")

But doing something is beyond what formulas can do.

 

[Keith]

Are you trying to do these two calculations together or separate?
if A1>500 and A1 <999 then do X
works for me,
but 500<A1<999 doesn't.

 

[Dave Peterson]

Oopsie!

This is a programming newsgroup question.

Sorry.