Creating Rating/Scoring System vs. Average Fee

[ballgame168]

Looking for help creating a formula that can determine how good a certain price is compared to an average price calculated in Airtable. For example, let’s say the average price of something in a record is $100. If my price is within 5% (+/-) of $100 (i.e. $95-$105) it should conditionally show “Average”. If between 5%-15% higher (i.e. $105-$115) it should conditionally show “Fair”. If more than 15% higher (i.e. $115+) it should conditionally show “Poor”. Alternatively, if between 5%-15% lower (i.e. $95-$85) it should conditionally show “Good”. And if more than 15% lower (i.e. $85-) it should conditionally show “Excellent”. Alternatively, a rating system (e.g. 1 star being the worse and 5 stars being the best) would work too.

Anyone know if something like this is possible and if so how to do it? Thanks in advance!

[ballgame168]

I think I figured it out (for the most part). Can someone spot check for me?

IF({Current Fee} >= 1.20*{Average Fee},“ :star: ”, IF({Current Fee} >= 1.05*{Average Fee} ,“ :star: :star: ”, IF(Current Fee} >= 0.95*{Average Fee} ,“ :star: :star: :star: ”, IF({Current Fee} >= 0.80*{Average Fee} ,“ :star: :star: :star: :star: ”, IF((Current Fee} < 0.80*{Average Fee} ,“ :star: :star: :star: :star: :star: ”)))))