Multiple if statement

Support
1

Ok so I have product sales performance ranking that is used to identify a category into which the sales ranked product falls. Based the following groups.
Sales ranking 1 to 50 is category A
Sales ranking 51 to 100 is category B and so on up to > 1000.
I am using the formula below in Excel but having difficulty is getting this or similar to work in Ragic. Can anyone suggest a fix?

=IF([@[Item-Store Rank (Last 6WK Sls)]]<50,“A”,IF([@[Item-Store Rank (Last 6WK Sls)]]<100,“B”,IF([@[Item-Store Rank (Last 6WK Sls)]]<250,“C”,IF([@[Item-Store Rank (Last 6WK Sls)]]<500,“D”,IF([@[Item-Store Rank (Last 6WK Sls)]]<750,“E”,IF([@[Item-Store Rank (Last 6WK Sls)]]<1000,“F”,IF([@[Item-Store Rank (Last 6WK Sls)]]>1000,“G”)))))))

2

Hi,

You can try the LOOKUP() formula:
https://www.ragic.com/intl/en/doc/18/Formulas#conditional_lookup

3

To clarify:
Are you saying that the filed equivalent to the one you have in Excel [@[Item-Store Rank (Last 6WK Sls)]] is in a record in Ragic, and it already has the ranking value: 1-1000?
And you want a formula that can tell you if i should be in category A-G?

If your field is in A1 (make sure it’s in number field type)
And you want the category in A2.
You should be able to achieve similar result by the following formula in A2.

**
E.g.:
IF(A1<50,’A’, IF(A1<100,”B”, IF(A1<250,“C”, IF(A1<500,“D”, IF(A1<750,“E”, IF(A1<1000,“F”, IF(A1>1000,“G”)))))))

You might wanna double check the sign you used to distinguish Strings, e.g.: ‘A’ or “A”.
Did you try something like this?

4

Thanks Jeremy, your question provided enough for me to take it from there. Problem solved, many thanks.