The Excel Expert
  • Welcome to the Excel Expert
  • Blog
  • Books for sale
    • Your Excel Survival Kit
      • Get the e-book plus bonuses here!
      • Buy on Amazon.co.uk
      • Buy on Amazon.com
      • Create Great Reports in Excel
      • Create Great Reports in Word
    • Get and Transform your data
  • Products for Sale
  • Free Webinars
  • Testimonials
  • About
    • Resources
    • About
    • Privacy Policy
    • Terms of Use
  • Contact
Select Page

EXCEL IF OR STATEMENTS

by admin | Aug 2, 2012 | Excel Formulas | Essential Functions, Excel | Intermediate Lessons

In a previous blog posting, I showed you how to set up an If statement in Excel. In this blog posting, I am going to show you how to nest an OR function into an IF function (the technique can be used equally well with a NOT, AND, TRUE, FALSE functions). Essentially...

Excel shortcut keys – FREE

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Categories

  • Excel – From The Beginning
  • Excel Formulas | Essential formulas
  • Excel Formulas | Essential Functions
  • Excel Functions | Useful
  • Excel Lists | List basics
  • Excel Lists | Sorting and Filtering
  • Excel Pivot tables | Introduction
  • Excel | Advanced Lessons
  • Excel | Case Studies
  • Excel | Conditional Formatting
  • Excel | Excel Beginner Lessons
  • Excel | Excel for Small business
  • Excel | General
  • Excel | Intermediate Lessons
  • Excel | Useful tricks
  • Personal
  • Powerpivot 2010
  • Training Records Management
  • Using Excel for tracking training

Like Excel Expert on Facebook

Recent Posts

  • Cleaning up emails
  • Calculating a Location Allowance – with conditions
  • Creating a Dashboard in Excel
  • 11 – How to freeze top row of large data set – View | Freeze Panes
  • Remove unwanted spaces using Trim() and combine multiple entries – 3 ways

Like Excel Expert on Facebook

  • Resources
  • Welcome to the Excel Expert
  • About
  • Blog
  • Contact
® 2019. All Rights Reserved