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?

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?