For example: it must not be cold and I must have clean shorts in order to wear shorts today. You can, however, build a group of rules together saying something must be false and something else must be true in order for the case to be true. Boolean Logic is named after a 19th century math and philosophy kind of guy George Boole.įor average humans, who didn’t invent a branch of math, this kind of logic is best thought of as evaluating a statement based on criteria as “TRUE” or “FALSE” (or as “1” and “0” respectively.) If part of a statement is false, the entire statement is false. 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 kommentar(er)
