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