{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?