dimanche 7 août 2016

Multiple conditions- if value between range display corresponding value

I tried to figure it out by myself and with the internet but I need your help.

I need to check a value is in few ranges and assign in the cell the corresponding value:

* all the numbers are integers

If the value is 0, display 1

if the value between 1 to 3, display 2

if the value between 4 to 6, display 3

if the value between 7 to 10, display 4

if the value is above 10, display 5

Tnx

Aucun commentaire:

Enregistrer un commentaire