Welcome again to Formula Friday, your pre weekend dose of Excel Formulaness.
Ok so today we will look at the very basics of using the IF formula in particular how to check if one number is greater than another. Very useful in Excel work.
As ever an example is always useful. Our scenario this time is to determine if a sales person managed to generate more sales leads this year than they generated last year.
The syntax of the formula is
=IF(LLOGICAL _TEST,VALUE _IF _TRUE,VALUE_IF_FALSE)
So, in our example we have two years of sales leads for our four sales people, column D for 2013 and E for 2014 to date..
Let’s go ahead and get Excel to tell us if the sales leads for each of our guys is greater this year than last.
The formula will be……
=IF(E6>D6,”More Leads”,”Less Leads”)
….this translates to if the value in E6 is greater than the value in D6, then insert More Leads, if it is not insert “Less Leads”, all we need to do then is drag the formula down the list of sales people for our full set of results.
That’s It Job Done!