We all have problems.
Excel is an executable. No more or less than 1’s and 0’s interpreted by your operating system. To its unsuspecting users it is perceived as a daunting application full of things that you keep meaning to learn more about. Just stop.
Excel is not the solution to your problems, you are.
Without an answer you are merely left with questions. Stop and ask yourself – What is the story I’m trying to tell? What information will I need to tell this story? The wheels should be turning at this point as you start to assess the possibilities. The introduction of comparison operators and IF statements will transition you from just being a recreational user to a true power user of Excel.
|Not Equal to||<>|
|Less Than or Equal To||<=|
|Greater Than or Equal To||>=|
Let’s use a simple question to review the total possibilities that exist by using the various comparison operators.
I want to know the number of kittens __ 10 years of age,
adopted from the dates __ June 1st 2015 and __ August 31th 2015.
- The number of combinations for a given number of items.
- The number can be any numerical value
- The number_chosen can be any numerical value
- number: 18 operators – (6 for each variable)
- number_chosen: 3 variables available
(1 Story to Tell / 816 Possible Stories = 0.1225% Guess Rate)
Even Kenny Rogers wouldn’t take those odds.
Data is full of possibilities, always ask the questions first –
Who? What? When? Where? Why?
That’s a bunch of Boolean and you know it!
You’re right, nothing comes easy when telling your story. IF this happens count this, IF that happens sum that. Constantly developing your cognitive skills in relation to logic, reasoning, memory and processing can undoubtedly lead to more meaningful data analysis on your part. The cognitive reasoning used when determining if something is TRUE and if something is FALSE is known as BOOLEAN when it comes to computer science.
- Return one value if a condition is true, another value if false
- logical_test is the condition for argument
- value_if_true is the result if true, can be both text or numerical
- value_if_false is the result if false, can be both text or numerical
- We can easily determine that 10 does not equal 11 so this would be FALSE
- Nothing has changed from our logical_test, our boolean values are now: “Dogs” = [value_if_true] and “Cats” = [value_if_false].
“If you’re going through hell, keep going.”
Practice, practice, practice. That feeling of being somewhat overwhelmed is called being on the verge of a breakthrough. Start building your own formulas using the comparison operators above with this lessons test workbook. If you want, you can get real crazy with it and research how to build even more advanced nested if formulas.