I am trying to do an analysis where I want to rename variables if they are between at set of numbers i.e.: if the value of [Field1] is >10 and <20, then the value is changed to something like "Page2" in the [Formula Field1]<br /> I know how to use the operators "=", ">" and "<", but I don't know how to do in between. I looked at the bucket function, but that seems to only work for dates and not other field types?
Have you tried the AND function? i.e. your formula becomes...
IF( AND( [Field]>10, [Field]<20 ), "Page2", [Field] )<br /> Thus, if the [Field] is both higher than 10 and less than 20 then it returns "Page 2". Otherwise it returns the value of [Field]. Hopefully this helps!