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 a...
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