Hi Dean_Toland,

Thank you for replying. Based on a suggestion from Victoria from Airtable’s customer service, I was able to solve my problem using a formula. It was a bit messy, but it does what I was trying to achieve. Here is the formula for the benefit of the community:

Please note the bunch of right parenthesis at the end of the formula. This was the more problematic part. The formula gave errors until I got the correct number of parenthesis.

IF({Seller Rating} <= 0, “”,IF(AND({Seller Rating} >= 0, {Seller Rating} <= 9), “”,IF(AND({Seller Rating} >= 10, {Seller Rating} <= 29), “”,IF(AND({Seller Rating} >= 30, {Seller Rating} <= 99), “”,IF(AND({Seller Rating} >= 100, {Seller Rating} <= 199), “”,IF(AND({Seller Rating} >= 200, {Seller Rating} <= 499), “”,IF(AND({Seller Rating} >= 500, {Seller Rating} <= 999), “”,IF(AND({Seller Rating} >= 1000, {Seller Rating} <= 1999), “”,IF(AND({Seller Rating} >= 2000, {Seller Rating} <= 4999), “”,IF(AND({Seller Rating} >= 5000, {Seller Rating} <= 9999), “”,IF(AND({Seller Rating} >= 10000, {Seller Rating} <= 19999), “”,IF(AND({Seller Rating} >= 20000, {Seller Rating} <= 49999), “”,IF(AND({Seller Rating} >= 50000, {Seller Rating} <= 99999), “”,IF(AND({Seller Rating} >= 100000, {Seller Rating} <= 199999), “”,IF(AND({Seller Rating} >= 200000, {Seller Rating} <= 399999), “”,IF({Seller Rating} >= 400000, “”,“Error”))))))))))))))))

So, basically it uses a string of symbols to identify Sellers based on their rating on Aliexpress.com. This formula is used a part of a table used to research possible product suppliers on Aliexpress.

I hope this helps if someone else needs to do a similar thing.