Need help on creating a new calculated column based on the conditions from other columns

Hi All

I have a requirement where I need to show when a attribute is out of range or no change(which are two separate column)  then output should be like"Attribute 1 is out of range and no change". Basically the new column should explain what's going on in those two columns. I have attached sample data and expected column in it.



File sample.xlsx8.73 KB

(2) Answers