Forum Discussion

AlecPatsey's avatar
AlecPatsey
Copper Contributor
Aug 17, 2022

Question about multiple conditionals

Thank you for your help in advance, I don't use excel much and I am struggling with syntax for filling in a column based on the values in the adjacent column. Mathematically it looks like this.

 

If 1200 < myValue < 2099 then return 3.

If 3000 < myValue < 4999 then return 4. 

If 5000 <  myValue < infinity then return 5. 

 

How can I encapsulate this to a single formula so I can drag it down the column to fill the entire sheet?

Thank you so much for your help again!

Resources