View original (French)

Google Sheets sum=0 issue

Solved
Flo -  
 Flo -
Good evening, I created a Google form and when a question is answered with a word, I want to give a numerical value to calculate customer satisfaction. However, when I sum all the numbers, I end up with zero...

=IF(C2 ="Mediocre","0",IF(C2="Bof","1",IF(C2="Correct","2",IF(C2="Excellent","3"))))

And when I sum all the calculations from this formula =SUM(M2:T2)

it shows 0, even though I've set all the cells to number format...

Thank you for your help.

2 answers

Answer 1 / 2
Pierr10 Posted messages 13810 Registration date   Status Moderator Last intervention   5 834
 
Bonsoir,

Dans ta formule supprime les guillemets qui encadrent chaque nombre. Sinon ils sont vus comme du texte et la somme ne donne évidemment rien !

=SI(C2 ="Médiocre";0;SI(C2="Bof";1;SI(C2="Correct";2;SI(C2="Excellent";3))))
1