Check field value range
Hey All --
I need to check a field for a value range in order to set a field.
if <$400 set to 1
if >$1000 then set to 3
But I don't know how to phrase if the range is >$400 but <$1000 then set it to 2
Can anyone assist me with this?