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