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!