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

But doing something is beyond what formulas can do.

DP7 wrote:

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

--

Dave Peterson