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

Being that several of your conditions never really change, you could take that into consideration.

if the

Categoryisbelow21 orover28, then it is out of range.Likewise, if the

Categoryisin range, then, if theInitValisbelow50000000 then it will beCat3, otherwise it will beCat4Now the problem has been reduced to only a few conditions can be written out as follows:

(or in pure javascript)

I hope that this helps.