How to Analyze Data Using IF Function in Excel

HOW TO ANALYZE DATA USING THE IF FUNCTION IN EXCEL // A very popular function in Excel is the IF function that returns one result if a statement is "true" and a different result if a statement is "false." Use the IF function when you have data in a column that you want to audit. This video's example shows you how to flag everyone whose salary is under a certain amount by saying IF the salary is over $100K, THEN mark as highly compensated, however, IF the salary is under $100K, THEN mark as needing an audit. Here is how the IF function works: =IF(logical_test, [value_if_true],[value_if_false]) HINT: When you want Excel to return a "text" value, use quotes "_" Likewise when you want the IF function to recognize a logical test with "text" use quotes in your formula. Numbers and cell references don't need quotes. So the example in this video uses the following (I can't type angled brackets in YouTube descriptions, so I spelled out greaterthan rather than using the symbol in the actual formula): =IF(A2greaterthan100000,"Highly Comp","Audit") By using this IF statement, I am able to create a column that recognizes anyone whose salary is over $100K by placing "Highly Comp" in the cell, therefore any salary not greater than $100K is marked as "Audit." __________ FREE DOWNLOADS: ✦ Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals. __________ CONNECT WITH ME: Visit my website: https://www.sharonsmithhr.com for more information, tools and resources. LinkedIn: https://www.linkedin.com/in/sharonsmithhr Twitter: https://twitter.com/SharonSmithHR __________ RESOURCES: I use clip art and templates from PresenterMedia and I highly recommend them. They have an amazing selection and excellent terms. Here is an affiliate link: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack= __________ NOTE: Some links included here are affiliate links. If you click on these links and make a purchase, we may earn a small commission at no additional cost to you. Thanks for supporting this channel! __________ KEYWORDS: #MSExcel, microsoft excel tutorial, IF Function, Excel IF Function, how to audit spreadsheet in excel, IF statement, IF statement in Excel, using IF function in Excel, Sharon Smith HR, @SharonSmithHR __________ PLAYLISTS: ➤ Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90 ➤ Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW ➤ Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45 ➤ PowerPoint Tutorials for HR: https://www.youtube.com/watch?v=XBl4hDLjtiI&list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM ➤ For HR Professionals: https://www.youtube.com/watch?v=5FxsWiqtXR4&list=PLb80efKTbWuNk9PyISH2lxRI0JBekYANI ➤ For Job Seekers: https://www.youtube.com/watch?v=PVjc-NUn0mo&list=PLb80efKTbWuNB9ex-F50NRgt_V26U9UPx ➤ Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR