Takeaway: This week, your challenge is to discover why a seemingly perfect IF() function returns the wrong result.
A user sends you a workbook with a simple IF() function that compares the text in two cells. If the two values are the same, the IF() function returns TRUE. When they don’t match, the IF() function returns FALSE. Simple, right? It should be, but there’s a fly in this one. Two cells (A4 and B4) contain the same text value, but the IF() function returns FALSE. Any idea what the culprit is?
There’s more than one possibility, so we made the downloadable example available.
Get IT Tips, news, and reviews delivered directly to your inbox by subscribing to TechRepublic’s free newsletters.
Susan Sales Harkins is an IT consultant, specializing in desktop solutions. Previously, she was editor in chief for The Cobb Group, the world's largest publisher of technical journals.
No messages found
Log in to display your contacts' posts.
Once logged in, adding contacts is simple. Just mouse over any member's photo or click any member's name then click the "Follow" button. You can easily manage your contacts within your account contacts page.
