Forum Discussion
Solved
Max function
I have a set of data in functions(the data is in function not manually added) and I want to determine the largest number of this data set but the function does not recognize the data as numbers but r...
- I was able to solve using the IFS formula I think were too many formulas for the formula to recognize
I was able to solve using the IFS formula I think were too many formulas for the formula to recognize
Luis_Maximo wrote: ``I think were too many formulas``
Another misinterpretation. The "&" operator returns a string. So
=IF(P3="NI";1;)&IF(P3="PI";2;)&IF(P3="I";3;)&IF(P3="PE";4;)&IF(P3="E";5;)
returns the string "1" or "2" etc or the null string if none of the conditions are true.
I suggested that you use ISTEXT to the type of the data that MAX sees.
It would behoove you to follow directions in the future.
That said, your solution of using IFS instead is good.