Help

Upcoming database upgrades. Airtable functionality will be reduced for ~15 minutes at 06:00 UTC on Feb. 4 / 10:00 pm PT on Feb. 3. Learn more here

Creating Rating/Scoring System vs. Average Fee

Topic Labels: Formulas
314 1
cancel
Showing results for 
Search instead for 
Did you mean: 

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!

1 Reply 1

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: ”)))))