Logical Formulae in Excel

Logical formulae are used to manipulate variables which can take only two values. For example, you may want to divide the data into two parts based on age - young (< 40 years) and old (>40 years). You can use logical formulae to do the same. The word 'logical' indicates either of two values, e.g. 1 or 0. 

The most commonly used logical functions are IF and OR, which you will learn in this segment.

Recall, so far, we've learnt about different kinds of formulae:

• Mathematical
• Statistical
• Text
• Logical

We've also learnt about Keyboard Shortcuts and some tricks in analysis (e.g.: Bucketing, Using Binary variables like 0 & 1, Use of Text to Columns and Remove Duplicates). Are you amazed at the speed at which Anand has performed this analysis? Have you observed the style of analysis i.e. Anand poses a business relevant question/hypotheses and uses the data to validate the hypotheses. 

Let's hear Anand talk about what enables him to perform analysis at such a speed.