Excel

IF, NOT, AND, OR To get more practice with the logic behind using the IF function with NOT, AND, OR logic: Below, I wanted to make a file where I showcase how I would use each in a AP/AR/Billing position such as my role as a Finance & Accounting Specialist. In my examples, I use them to see the following: 1) if we are billing over budget 2) if we have any urgent amounts to pay 3) if invoice is okay to pay as long as we billed client and receive client payment 4) if an invoice is due within 30 days.

IF, NOT, OR If it is either this or that, then mark and x. Either wise, do not mark it as an x. (i.e. Red or Green) If it is neither this or that, then mark an x. Either wise, do not mark it as an x. (i.e. Neither Red or Green) Below, I do a version 1 formula without using a constant array and formulas that uses constant array and produces same result.