Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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))))) |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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? |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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))))) |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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? |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
=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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
XL2002 - OFFSET function and LARGE function | Excel Worksheet Functions | |||
INT Function Returns 1 | Excel Worksheet Functions | |||
Excel function LARGE returns error 'too few arguments' | Excel Worksheet Functions | |||
Divide LARGE if multiple returns | Excel Discussion (Misc queries) | |||
dsum returns 0 if criteria range too large | Excel Worksheet Functions |