Visokio website     Downloads     Video tutorials     KnowledgeBase  
Formulae: bracketing values using IF logic? - Visokio Forums
Formulae: bracketing values using IF logic?
  • kantia8 November 5, 2014 5:36PM
    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?
  • DBuzacott November 5, 2014 6:03PM
    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!
  • kantia8 November 5, 2014 6:57PM
    Yep, this is exactly what I needed


It looks like you're new here. If you want to get involved, click one of these buttons!

Sign In Apply for Membership