If This, Then That with Excel

If-that-then-that-function-in-excel

Whether you're creating a complex mail merge or simply need to transform your data in Excel, the IF function is a simple but powerful tool. Get started with a condition - an expression that outputs as true or false. For example, does A1 contain "yes"? Either it does (true) or it doesn't (false). Then, you tell Excel what to output when the expression is true and what to output when the expression is false. Use it to merge the right text into a Word document or display your data differently within Excel.

Watch the video to see it in action!

 

Don't miss another one of our live training sessions - subscribe here.

If you are interested in more training videos, or if you're ready to create a culture of training in your organization, discover all that Affinity Insight has to offer. Or, if you have any questions about Microsoft Word’s AutoText or any other functions, contact us at 877-676-5492 or request a consultation. Our team of experts is ready to help


Danielle DavisRoe

Written by Danielle DavisRoe

Danielle’s many responsibilities at Affinity include training, CLE/speaking, writing, and management consulting. Prior to joining the Affinity family, Danielle practiced family law. She discovered, however, that she enjoyed making efficient use of technology more than practicing law, making her a perfect fit for consulting. Danielle describes her superpower as “herding cats,” and her favorite parts of her job are making others’ jobs and lives easier.

New call-to-action

Recent Posts