Search results for query: *

You're right. That's awesome! Regards, Joerd

@Gavona Just multiply that 0 result by 1E10 or so, and see the answer. Thanks for the link, btw. Regards, Joerd

Thanks John, should've thought about that myself. Turns out that (at least in Excel 2003): (0.2+0.1-0.3) equals 5.6E-17 and not 0 Would have been nice if this had been fixed before 2007, but we're all learning. The same functionality that allows 5.6E-17 to be displayed as 0 could have been used...

Yes, it's causing a problem, and no, I'm not a computer science student. The problem I presented is not my actual case, but representative of the error. The problem is that it's easy to miss the error, especially if you're doing a range lookup, and then continue working with the wrong answer -...

I recently found a strange error using VLOOKUP (actually, MATCH does the same): In cell A6, type 0.1 In cell A7, type =A6+0.1 and copy down to A25 Copy A6:A25 to B6:B25 In cell C6, type =VLOOKUP(B6,A$6:A$25,1,FALSE) and copy down to C25 All looks fine, but now copy A6:A25, and paste...

You could also try a VLOOKUP function. Regards, Joerd

why not change the order of columns B and C, and then use, in cell D1 =VLOOKUP(A1,$B$1:$C$200,2,false) and copy this formula down to D2:D200 Regards, Joerd

You have to write a visual basic function such as: Function BackgroundColor(R As Range) As Variant BackgroundColor = R.Interior.ColorIndex End Function Regards, Joerd

Seems to me you need something like =ROUNDUP(A1*20,0)/20 Regards, Joerd

check out http://www.cpearson.com/excel/lists.htm or you may consider the TRANSPOSE function (quoting David McRitchie) See HELP for use of the TRANSPOSE Worksheet Function, so that you can change data on the first sheet later and be reflected in the other sheet. It will be tricky as it must be...

This is through an addin called autosave.xla, which should be in your office\library subdirectory. The provided addin by MS is not the greatest, there are better (also free) solutions around. Search the internet! Regards, Joerd

The type of variable returned by vlookup is the same type as the source data. So if you have text in the source data column, vlookup returns text. Sometimes, Excel treats numbers as text. So they look like a value, but it is actually a text entry. This happens - as far as I've seen - when 1...