Tuesday Tip: “IF” only Excel could

By: Chase Petersen

Excel is widely used across just about every business sector so I find it useful to continue educating myself on how to best use the program.  The more formulas and shortcuts you can master the more useful, and better you will be at excel.

One formula I found to be very useful is the “If” statement formula.  It works by looking at a cell value in a true/false point of view and outputting the corresponding response.  For example you could write: =IF(B2<=50,”Fail”,”Pass”).  Which would calculate if B2 is Less than 50 it would respond with the text Fail and if it was greater than it would respond with the text Pass.

The beauty of this formula is that it is highly customizable – the first section is a logic test, the second is the positive response, and the third is the negative response.  You can use this formula in just about any way you see fit.  Once you start to understand how to use the formula, a very useful trick is to nest IF statements.  Nesting is where you create an if statement, logic test, and positive response but in the negative response you create another IF statement.

By nesting you can create If statements that deal with more than two options.  The nested IF statement can handle more than a “if this/if not this” and converts to a “if this/then this/then this” which can be used in a multitude of ways to make your excel sheets flow.

 

Chase Petersen: Chase works at Network 1 as a Sales Operations Associate, where he partners with clients to learn their needs and provide thoughtful recommendations on how to meet each one. He is a graduate of Kennesaw State University where he earned his degree in Economics and Political Science.

Network 1 designs, builds and supports the IT you need to run your business more securely, productively and successfully. Whether you want to outsource all of your IT needs to a reliable, responsive, service-oriented company, or need to supplement the work of your internal IT staff, we will carefully evaluate where you are now, discuss where you want to go and implement and support a plan to get you there with as little interruption as possible.

Leave a Comment





Related Posts