| 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? |
| 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 | |||
Threaded Mode
