![]() ![]() Boolean logic is required for some types of Excel formulas and takes a few minutes to understand, but this kind of thinking is useful when you basically live inside of Excel spreadsheets and want to get a computer to think for you. Here we are at an intersection of my recent outside-of-work reading and listening about physics, math, and philosophy with my everyday work in Excel. Let’s get to it by starting with some background. Nor am I for that matter, but maybe you are. ![]() The functions we will use in this way are not smart enough to do that task. For example: if you are looking for “Los Angeles”, you won’t find what you are looking for if “LA” is listed as a city inside of an address using this method. To clarify, doing things this way still requires the item you are looking up to be found inside of something else, so in that sense, this is not the truest form of what a “fuzzy” lookup could be. In order to get fuzzy when looking up items, we need to learn about not one but two things: Boolean Logic and the Excel SEARCH function.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |