Hi Guys
I have another question similar to my last post.
In cell A1 if I have a value of 599 or less I need cell A2 to produce a value of 1
And similar if cell A1 has a value of 600 or more I need cell A2 to produce a value of 2. I tried to build something from the last formula you guys gave me along the lines of

=IF(A1<=599,A1=1)
But it’s not working for me.
Thanks for your help so far.
Dodge.