mardi 8 décembre 2020

Excel if with 3 values

I would like to create an excel if-statement that results in 1 of 3 values. In one cell in a column I have a number that is from -500 to 500. In another cell column I like to get "W" if it's above 7, "L" if it's below -7 and "X" if it is between -6 and 6. I have tried with the following:

=IF((R68)<-7,"L",IF((R68)>7,"W","X")) but only get W and L.

/Britt

Aucun commentaire:

Enregistrer un commentaire