vendredi 11 septembre 2020

If Statement with multiple conditions on one column

I want to create an if statement where I can get a value in my new cell if the values or strings in one column are either 0-1,000 or 1001-5,00, then 2, if they are only 5,001-10,00 then I get 4 and if it is 10,000+ then I get 4.?

SO far I only have something like =IF($U502="10,000+",5,0) and =IF($U502="5,001-10,00",1,0)

where i get 5 if it is 10,000+ and 1 if it is 5,001-10,000

I want to combine them both into one formula and also add that if the value is also either 0-1,000 or 1001-5,000 then 3

Thanks

Aucun commentaire:

Enregistrer un commentaire