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



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


    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