by Crispo Mwangi | Nov 9, 2022 | BASIC EXCEL
Unlike the OR function which returns TRUE if only 1 condition is TRUE, the XOR function returns TRUE if the number of TRUE conditions is ODD and FALSE if the number of TRUE Conditions is EVEN. Like the OR Function, at least one of the test conditions must evaluate to...
by Crispo Mwangi | Nov 4, 2022 | BASIC EXCEL
When testing for multiple conditions, OR logic is used to determine if ANY condition in the test is TRUE. The only time OR function evaluates to FALSE is if all conditions in a test are false =OR( 2>5, 6>5 ) will evaluate to TRUE though the first logical test...
by Crispo Mwangi | Sep 30, 2022 | BASIC EXCEL
This is part 1 of the 4 part series on What if analysis. This blog will cover the Goal Seek feature. What is the Goal Seek feature? Goal seek enables you to see how a change in one value in a model can change the final result. Instead of guessing what impact a value...
by Crispo Mwangi | Sep 23, 2022 | BASIC EXCEL
If you are not using the excel fill series in your day-to-day tasks you are wasting a lot of time You can quickly enter sequential numbers or numbers following a pattern using the Autofill options. And since excel stores Dates & Times as numbers, these can also be...
by Crispo Mwangi | Sep 9, 2022 | BASIC EXCEL
The SEARCH and FIND functions in excel both return the position of a text in a text string. For example, what is the position of the text “Air” in “American Airlines Group”? Both functions return 10 which means the text “Air” starts...
by Crispo Mwangi | Aug 10, 2022 | BASIC EXCEL
The first step in counting distinct, unique, and Duplicates is knowing the difference between distinct and Unique. ⭐ Distinct refers to a count of items in a list after removing duplicates ⭐ Unique refers to a count of items in a list that appears ONLY ONCE. Distinct...
Recent Comments