Forum Discussion
AlecPatsey
Aug 17, 2022Copper Contributor
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!