Excel 2007 bug or ...?

  • Thread starter Thread starter Zeljko
  • Start date Start date
Z

Zeljko

Excel 2007

In A1:B7 put this numbers:
6 550
8 560
10 570
12 580
14 590
16 600
18 610

In D1 put number: 0,14
In D2 put formula: =VLOOKUP((D1*100);A1:B7;2;FALSE)

Wenn you enter any other number in D1 (0,06 or 0,18 or 0,12) formula returns correct value but if you enter in D1 number 0,14
formula returns #N/A error?!
Why?
Also if i put in vlookup True then I also get values greather then 18 and I dont want that.
Can somebody test that in excel and maybe reproduce that error?
 
Excel 2007

In A1:B7 put this numbers:
6 550
8 560
10 570
12 580
14 590
16 600
18 610

In D1 put number: 0,14
In D2 put formula: =VLOOKUP((D1*100);A1:B7;2;FALSE)

Wenn you enter any other number in D1 (0,06 or 0,18 or 0,12) formula returns correct value but if you enter in D1 number 0,14
formula returns #N/A error?!
Why?
Also if i put in vlookup True then I also get values greather then 18 and I dont want that.
Can somebody test that in excel and maybe reproduce that error?
Click to expand...

Happens in 2003 too.
It's just the usual rounding error.
You need to use...

=VLOOKUP(ROUND(D1*100,0),A1:B7,2,FALSE)

Ken Johnson
 
Back
Top