The document provides instructions for making a quick fake list of 10 students and discusses setting up a weekly newsletter from XelPlus that contains helpful tips and the latest news related to Microsoft Excel and other popular Office apps. It also includes examples of Excel formulas to check if a cell contains a certain word and evaluate conditions across multiple cells.
The document provides instructions for making a quick fake list of 10 students and discusses setting up a weekly newsletter from XelPlus that contains helpful tips and the latest news related to Microsoft Excel and other popular Office apps. It also includes examples of Excel formulas to check if a cell contains a certain word and evaluate conditions across multiple cells.
The document provides instructions for making a quick fake list of 10 students and discusses setting up a weekly newsletter from XelPlus that contains helpful tips and the latest news related to Microsoft Excel and other popular Office apps. It also includes examples of Excel formulas to check if a cell contains a certain word and evaluate conditions across multiple cells.
The document provides instructions for making a quick fake list of 10 students and discusses setting up a weekly newsletter from XelPlus that contains helpful tips and the latest news related to Microsoft Excel and other popular Office apps. It also includes examples of Excel formulas to check if a cell contains a certain word and evaluate conditions across multiple cells.
Download as XLSX, PDF, TXT or read online from Scribd
Download as xlsx, pdf, or txt
You are on page 1of 7
ASK the
A.I BOT
make a quick fake list of 10 students
ASK
This is an image - It will not
work if you click it. You'll need to save the Office Script to your OneDrive/SharePoint and then insert a button that executes that script. ALWAYS BE LEARNING. That's my motto and our 300,000+ students. Join our XelPlus weekly newsletter packed with helpful tips and the latest news related to Microsoft Excel and other popular Office apps. From shortcuts and formulas to new features and updates, our newsletter has everything you need to stay on top of the latest trends and boost your productivity.
his is an image - It will not
ork if you click it. ou'll need to save the Office cript to your neDrive/SharePoint and hen insert a button that xecutes that script. Employee Meets deadline Is Polite Next steps Tim No Yes If both values in cell Poldi No No and C2 are "No" the Sara Yes Yes return "Have a talk", otherwise return "A good". If both values in cell B2 and C2 are "No" then return "Have a talk", otherwise return "All good". Employee Includes video? Edit video admin tasks Write an Excel formula: If cell A2 Record a video includes the word "video" then Team meeting return "YES" otherwise return "No". For example if A2 is "This is video script the video group" then the formula should return "YES".
This formula doesn't work:
=IF(A2="*video*","YES","NO") API Key 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 Check out this video to find out how: https://youtu.be/kQPUWryXwag