B
Bryan Gnidrah
I have the following function to determine the largest value in a range of
data =LARGE(A1:A10,1). It works fine when the data is input manually
1,2,3,2,1,1,1, etc, however returns #NUM! on the range of data generated by
function. The function in each of the cells i want to find the highest value
of determines the numeric value of text in another cell. That function is
=IF(K4="Extremely
High","3",IF(K4="High","3",IF(K4="Medium","2",IF(K4="Low","1",IF(K4="","1")))))
Can anyone help?
data =LARGE(A1:A10,1). It works fine when the data is input manually
1,2,3,2,1,1,1, etc, however returns #NUM! on the range of data generated by
function. The function in each of the cells i want to find the highest value
of determines the numeric value of text in another cell. That function is
=IF(K4="Extremely
High","3",IF(K4="High","3",IF(K4="Medium","2",IF(K4="Low","1",IF(K4="","1")))))
Can anyone help?