Skip to main content

Results for: Excel

Selected page 1

Microsoft Excel is the industry leading spreadsheet software program, a powerful data visualization and analysis tool. Take your analytics to the next level with Excel.

Excel for the web. Organize your data in familiar spreadsheets and workbooks, with all changes saved automatically. Create modern visuals that turn numbers into valuable insights. Work together in real time knowing that everyone is on the same page. Start using Excel.

You can always ask an expert in the Excel Tech Community, get support in the Answers community, or suggest a new feature or improvement on Excel User Voice. Related Topics. Video: Advanced IF functions Learn how to use nested functions in a formula IF function AND function OR function Overview of formulas in Excel How to avoid broken formulas

If you want to play with it in a sample workbook, see the end of this article. =OR (AND (C2>DATE (2011,4,30),C2<DATE (2012,1,1)),B2="Nancy") Let's go a bit deeper into the formula. The OR function requires a set of arguments (pieces of data) that it can test to see if they're true or false. In this formula, the first argument is the AND ...