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