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.

IF, AND, OR More practice with the IF, AND, OR logic formula. I used the IF and OR to identify certain colored apples and mark an x if so. I used the IF & AND to determine if it is a round apple or not.

IF and OR Constant Array See below 2 examples using IF and OR logic together. The first example is returning whether the individual pass or fail if either test is over 50. The second example is returning whether the invoice is okay to pay if the status column is either billed to client or cash receipt entered (client paid). For the second example, I need to use a constant array, a hard-coded set of values provided in an Excel formula for "Billed to Client" and "Cash Receipt Entered." A curly brace is used within the IF formula.