Formula for sending feedback on an average or score? Solved

Question

Hello everyone,  I'm looking for a formula that allows me to return an appreciation of a value (average or score) that is found, for example, in A1 and should be displayed in F16: In A1, there is the average or score which can vary from 0 to a maximum of 10, and in F16, I need to have one of the appreciations depending on the level of the average or score: Examples: 0 to 2.99 = "Very low", 3 to 3.99 = "low", 4 to 5.99 = "average", and so on... So each appreciation corresponds to a range of values for the average or score, and at any time the score can change, and I want the appreciation to change automatically as well.  Thank you in advance for your help  Best regards

ccm81 · Answer

Hello  In F16 =IF(A1

sekouausud · Answer

Hello, I tried the proposed formula and I got "#VALUE!" in F16.  I should specify that in A1 some of the average values in question are decimal numbers like 2.42.  Also, the value in A1 comes from another sheet in the same workbook where all the averages are calculated, and I copied the corresponding average to then "paste link" in A1.

PHILOU10120 · Answer

Hello  In F16, enter this formula  =CHOOSE(A1; "very low"; "low"; "fair"; "average"; "medium"; "fairly good"; "good"; "very good"; "great"; "super good")  You need 10 ratings or 5 repeated twice  In case the cell is empty or 0  =IF(A1=""; ""; IF(A1=0; "nil"; CHOOSE(A1;"very low"; "very low"; "low"; "low"; "medium"; "medium"; "good"; "good"; "very good"; "excellent")))  It is by forging that one becomes a blacksmith. - It is at the foot of the wall that one sees the mason - one always learns from one's mistakes.

sekouausud · Answer

Thank you, PHILOU10120  I'm limited in Excel, so I don't understand your formula; where are the limit numbers for each of the assessments?  If possible, I would like to have the complete formula explicitly which takes into account IF A1

ccm81 · Answer

You may not have properly continued the formula Try this, I added the case where A1 is empty as suggested by our friend PHILOU10120 =IF(A1="","",IF(A1<3,"low",IF(A1<4,"mediocre",IF(A1<6,"passable",IF(A1<7,"pretty good",IF(A1<0,"good","very good"))))))  Best regards

sekouausud · Answer

Hello, This time, the formula works just as I wanted.  Thank you very much, especially for your availability.  Best regards

Formula for sending feedback on an average or score?

6 answers

How to connect: the desktop to my tv

Block unwanted calls

How to restore the messages icon

Latest versions of camera raw and photoshop

These next-generation gmos will soon be in our fields and on our plates

Connecting a sony handycam video 8 ccd f555e to an hd tv

Unable to delete facebook account

Direct streaming problem from pc to tv via hdmi port

Computer changes colors

Landline phone dead, base blinking