Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
LARGE / RANK FORMULA ERROR
{Excel2003}
The following formula is made to show the value above the value that is picked. =IF($H$14=4.8,5.76,LARGE($N$3:$N$12,RANK(H14,$N$3: $N$12)-1)) h14 is always one of the values from the list: The list N3: N12 is: 4.80 4.56 4.32 3.96 3.60 3.12 2.64 2.16 1.50 1.00 The formula is working for some of the values. But when it reads $3.60 it displays #N/A instead of $3.96 Any ideas? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
rank function error | Excel Worksheet Functions | |||
Having Trouble with the RANK Function...Try LARGE or SMALL Functio | Excel Worksheet Functions | |||
error displaying large numbers | Excel Discussion (Misc queries) | |||
VBA Compile error: Procedure too large? | Excel Discussion (Misc queries) | |||
Rank items, select one start date, have remaining dates follow based on rank | Excel Discussion (Misc queries) |