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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
LARGE / RANK FORMULA ERROR
Works OK for me.
So, either H14 is TEXT or the 3.60 in your list is TEXT. If it works "sometimes" then I'd lean towards the 3.60 in your list being TEXT. Try re-entering it. -- Biff Microsoft Excel MVP "dj479794" wrote in message ... {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? |
Reply |
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) |