AnsweredAssumed Answered

I have several if statements I'd like to join together into one statement in a calculated value

Question asked by julesnye on Jun 29, 2017
Latest reply on Jul 4, 2017 by euang

e.g.

 

If(AND(Category<"28", Category>="21", InitVal>="50000000” ),"Cat4","")
If(AND(Category>="21",Category<"28",InitVal<"50000000" ),"Cat3","")
If(AND(Category<"28", Category>="21", InitVal<"50000000”, InitVal>="5000000” ),"Cat3","")
If(AND(Category<"28", Category>="21", InitVal<"5000000”, InitVal>="1000000” ),"Cat3","")
If(AND(Category<"28", Category>="21", InitVal<"1000000” ),"Cat3","")

 

What I'm trying to do, is have just one calculated value on my form incorporating the above if statements.

Does anyone know how to do this.

 

I want it to work like:

 

if it's this or this then blahblah

  or

    if it's this or this then blahblah etc.

 

To behave like a case statement ideally

 

I've tried quite a few ways of getting the result but it just freezes the form when reloaind it.

Any help would be greatly appreciated.

Kind regards

Julian

Outcomes