Forty tea orders pass through IF, AND, OR and IFS tests against thresholds kept in labeled cells in this finished IT153 Unit 4 logical functions exercise. Searches like "it 153 unit 4 assignment example", "it153 unit 4 sample" and "it153 unit 4 example" land here.
What a finished IT153 Unit 4 logical functions exercise looks like
A settings block in A1:B4 holds the free-shipping threshold of $50, the standard shipping charge of $6.95 and the expedited minimum of $75, each labeled. The order table starts in row 7: order number, customer type, member or guest, subtotal, gift flag, rush flag and destination region. Column H returns the shipping charge with IF, zero when the subtotal meets the threshold and the standard charge otherwise. Column I uses AND to mark Expedited only when the customer is a member and the subtotal clears $75. Column J uses OR to print Handle First when an order is either a gift or a rush. Column K assigns a packing label by region with IFS, falling back to Standard Box. A walkthrough tab restates each test as an ordinary sentence.
How a IT153 Unit 4 example is structured
Each logical column answers one yes-or-no question, and the example keeps them separate rather than nesting everything into a single long formula, which makes each test readable and each result checkable. Thresholds live in the settings block and are referenced absolutely, so the shop can move its free-shipping line from $50 to $60 without touching a formula. The order of tests matters in the IFS column, and the sheet arranges them from most specific to most general, with a final TRUE condition catching every other region. Text results are spelled consistently, since a later filter or COUNTIF will match them exactly. Below the table, COUNTIF tallies how many orders shipped free, how many went expedited and how many were flagged, a quick proof that the logic behaves across the whole data set.
Settings block
Three labeled inputs for the free-shipping threshold, the standard charge and the expedited minimum. Every logical formula points at these cells absolutely, so policy changes happen in one place.
Shipping charge with IF
One condition, two outcomes: zero at or above the threshold, the standard charge below it. Orders sitting exactly at $50 are included in the sample data deliberately, to show that the comparison uses greater than or equal to.
Expedited with AND, Handle First with OR
AND requires both membership and a subtotal over the minimum; OR needs either a gift or a rush flag. The two columns sit side by side so the difference between the functions reads directly from the results.
Packing label with IFS
Four regions tested in order, each returning a named box type, with TRUE as the last condition so no order is left without a label. A nested IF version appears in the walkthrough for comparison.
Proof counts and walkthrough
COUNTIF totals under the table confirm the logic across all forty orders, and the walkthrough tab writes each test as a sentence, such as if the subtotal is at least the threshold, shipping is free.
Where marks go in IT153 Unit 4
Logical exercises lose points in the conditions more than in the syntax. The boundary case is the classic: a test written as greater than 50 when the rule says at least 50, so a $50 order is charged shipping. Thresholds typed into formulas instead of referenced from input cells cost the input row and make the sheet brittle. An OR written where AND belongs, so any member qualifies for expedited regardless of order size, produces results that look plausible until a grader filters for them. Nested IFs missing a final outcome return FALSE into a label column. Text outputs spelled two ways, Handle First in one row and Handle-first in another, quietly break the COUNTIF that follows. The sheets that score well test the boundary rows deliberately and say in writing what each condition means.
Get a IT153 Unit 4 example written to your instructions
Rules stated in words, a discount threshold or a pass mark, become the logical tests, so the Unit 4 prompt matters more than usual here. Forward it with the data and rubric your IT153 instructor posted. The sample returns within 24-48h with a walkthrough of every condition. There is no charge for a first custom sample.
IT153 Unit 4 questions, answered
Should I use nested IFs or IFS?
Either works in current Excel, and your prompt may name one. IFS is easier to read because each condition sits beside its result without layers of parentheses, but older versions of Excel do not support it. Nested IF remains common in course materials. The sample uses IFS and shows the nested equivalent in its walkthrough, so both forms are visible.
My IF formula returns FALSE. What went wrong?
An IF that returns FALSE is usually missing its third argument, the value to show when the condition is not met, and Excel fills the gap with FALSE. Adding the missing outcome, even an empty pair of quotation marks for a blank, fixes it. In nested formulas the same problem appears when the innermost IF has no final fallback.
How do the AND function and the OR function work inside IF?
AND returns TRUE only when every condition inside it is true; OR returns TRUE when at least one is. Placed inside IF, they let a single decision depend on several facts, such as membership and order size together. The easiest check is a few test rows chosen to make each condition true or false in turn, which the sample data includes.