mardi 20 mars 2018

multiple conditions in excel showing points

I'm trying to make multiple functions where it shows a certain point if..

multiple conditions in excel showing points

if A1 is bigger than 500 shows 0
if A1 is smaller than 500 but greater than 200 then shows 0.3
if A1 is smaller than 200 but greater than 100 then shows 0.6
if A1 is smaller than 100 then shows 1

Thank you

Aucun commentaire:

Enregistrer un commentaire