Thanks,
I posted the formula on Petes reply. Take a look and tell me if the problem
could be on the data side. I download the excel sheet from a lender.
Thanks

"L. Howard Kittle" wrote:

Hi Landon,

I think Pete nailed your problem. The table should be something like:

$A$1:$C$6 and you have

A1:C6

HTH
Regards,
Howard

"Landon C" wrote in message
...
I have a table like this

a b c
6.75 -.75
6.875 -1.25
7.0 -2.0
7.125 -2.125
7.375 -2.75
7.5 -3.0

Everything works fine on my spreadsheet until I change from 7 to 7.125. It
returns the same value(-2.0). I don't know what I am doing wrong. Please
help.
Landon