Excel

Multiple Condition IF Below, I made up a scenario where a seller is offering 1 item for $2.00, 2 to 9 items for $1.50 each, and 10 items or more for $1.00 each.  In green is the syntax for the IF statement and a IF AND statement. The idea is that if the first condition is not true, then it will check if the next condition is true. If the second condition is not true, then it will check if the third condition is true. Finally, in the How Many Purchased Column is a Data Validation that only allows for whole numbers from 1 through a 100 to prevent any decimals or nothing purchased scenario. 

IF  &  Operators Below is file with example of arithmetic operators and comparison operator. I used the if statement along with comparison operator to determine result of "fail", "pass", or "perfect." I also used a conditional formatting rule to fill a certain color for each result.