Excel, or Google Sheets if you prefer, are both powerful tools for digital marketers. They not only let us visualize data in graphs and charts, but they have loads for formulas built in to further refine the type of analysis we can do and the speed at which we can draw insights.
One formula that looks scary but has a ton of power behind it is the IF statement. The statement itself looks like this:
=IF(logic check,value to return when logic is true, value to return when logic is false)
What it does is checks for a specific condition, and if that condition is true, returns a value. When the condition is false, it returns a different value. Here’s an example if we wanted to check whether sales are at or above $500M in a given quarter.
=IF([cell to check value of]>499, “Y”, “N”
|Quarter||Total Sales ($m)||Quarter above $500m|
This is a simple example, but the opportunities are vast for the IF statement. Here is another useful real-life situation I’ve found valuable.
You have a set of data with a wide variance in values.
Application of IF statement
Use the IF statement to group values into logical buckets for your business. Say you wanted to separate products with less than $100M in sales from products with more than $100M in sales. You could do something like this…
=IF([cell to check value of]>99, “Greater than $100 in sales”, “Less than $100 in sales”
|SKU||Total Sales ($m)||Sale Bucket ($m)|
|A123||$5||Less than $100 in sales|
|B123||$25||Less than $100 in sales|
|C123||$500||Greater than $100 in sales|
|D123||$101||Greater than $100 in sales|
When you consider a real data set that would have thousands of SKUs and could be broken down further by time range – using the IF statement to group sales into buckets can be very useful – especially if you plan on taking it ot a pivot table.
A few other examples for useful applications of the IF statement involve nesting, so we’ll save those for later – after we talk about nesting.
Any IF statements scenarios that have made your life easier – tell us about them.
Pingback: Formulas You Should Know | SUMIF - A Real Marketer