Forum Discussion
Help to sort out high grade objects
The formula is;
=IF(AND(AG23=blue;AND(AK23>2;AL23>2));"pink";"")
It is supposed to sort out the high grade samples (pink) from moderate grade samples (blue)
If the values of AK23 and AL23 are higher than 2 and AG23 is blue I want it to display pink in this field. If not, dont display anything. It's not working, can you help me point out mistakes or tricks.
7 Replies
- I just want the word "pink" in the cell if blue has a higher grade than 2.
Hi Jessica,
If, as in your example, if you have in AG23 the text "blue" and, based on this and combination of some other criterias you'd like to change the text in the same AG23 on "pink", that's not possible. At least by using formulas. You can't take the value from the cell, make some transformations depends on this cell value and return the result into the same cell.
You may change "blue", "pink", etc in AG23 depending on values in other cells, but not depending on what it was in AG23 before. Or you may add above text in one more cell which will be changed depends on AG23 and other cells values.
I added a picture of the formula. So the cell I want to give me the answer is AH, if the AG is blue and (AI or AJ is above 2). Its all in swedish, sorry about that.
- input Known_y's, Known_x's, The formula is =_xlfn.FORECAST.ETS(A61;$B$4:$B$60;$A$4:$A$60;1;1) output is #NAME ?
Hi Viet,
Please ask separate questions in separate conversations. As for the error please check https://support.office.com/en-us/article/Issue-An-xlfn-prefix-is-displayed-in-front-of-a-formula-882F1EF7-68FB-4FCD-8D54-9FBB77FD5025
Hi Jassica,
Do you mean conditional formatting or just words "blue", "pink" in the cells?
