=Large function returns #NUM!
 

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(K 4="Low","1",IF(K4="","1")))))

Can anyone help?

=Large function returns #NUM!
 

Bryan Gnidrah wrote:
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(K 4="Low","1",IF(K4="","1")))))

Can anyone help?

Remove all of the quotes (") around the numbers.


=IF(K4="Extremely High",3,IF(K4="High",3,
IF(K4="Medium",2,IF(K4="Low",1,IF(K4="",1)))))

=Large function returns #NUM!
 

Those numbers that you are returning from your function are actually
text values, because you have put quotes around them - drop the
quotes, like this:

=IF(K4="Extremely High",3,IF(K4="High",3,IF(K4="Medium",2,IF(K4="Low ",
1,IF(K4="",1)*))))

Hope this helps.

Pete

On Feb 17, 7:24*pm, Bryan Gnidrah <Bryan
wrote:
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(K 4="Low","1",IF(K4="","1")*))))

Can anyone help?

=Large function returns #NUM!
 

Glen,

Thanks for that. Its oftern the simplest of things that trip us up!

"Glenn" wrote:

Bryan Gnidrah wrote:
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(K 4="Low","1",IF(K4="","1")))))

Can anyone help?

Remove all of the quotes (") around the numbers.


=IF(K4="Extremely High",3,IF(K4="High",3,
IF(K4="Medium",2,IF(K4="Low",1,IF(K4="",1)))))

=Large function returns #NUM!
 

Thanks Pete.

"Pete_UK" wrote:

Those numbers that you are returning from your function are actually
text values, because you have put quotes around them - drop the
quotes, like this:

=IF(K4="Extremely High",3,IF(K4="High",3,IF(K4="Medium",2,IF(K4="Low ",
1,IF(K4="",1)Â*))))

Hope this helps.

Pete

On Feb 17, 7:24 pm, Bryan Gnidrah <Bryan
wrote:
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(K 4="Low","1",IF(K4="","1")Â*))))

Can anyone help?

=Large function returns #NUM!
 

You're welcome, Bryan - thanks for taking the trouble to feed back.

Pete

On Feb 17, 8:01*pm, Bryan Gnidrah
wrote:
Thanks Pete.