Hi
I want to use a calc element to return a value that falls within a certain range, when that value is entered in another field: eg between 1 - 10 return A, between 11 - 20 return B etc etc. I have got IF/ELSE statements in the calc to do this.
This is working very well but my question is, is there a limit to how many IF/ELSE statements are suitable for one calc? I am thinking I might want about 100 in this calc, does this seem to many? I have got 10 or so at the moment and it seems fine, but wanted to get some advise before continuing.
Kind Regards
I want to use a calc element to return a value that falls within a certain range, when that value is entered in another field: eg between 1 - 10 return A, between 11 - 20 return B etc etc. I have got IF/ELSE statements in the calc to do this.
This is working very well but my question is, is there a limit to how many IF/ELSE statements are suitable for one calc? I am thinking I might want about 100 in this calc, does this seem to many? I have got 10 or so at the moment and it seems fine, but wanted to get some advise before continuing.
Kind Regards