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

"DP7" wrote in message
...
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