LXLogicExcel
🔥
0
⭐
0
← Lookups and Logic

Lesson 1 of 5

IF: making a formula decide

What you will be able to do

Write an IF that returns one of two results, combine conditions with AND and OR, and choose IFS over a nested tower.

Ridgeline pays a bonus on orders over $1,000. Thirty-one of the 314 orders qualify. You are not going to find them by eye, and you are not going to mark them by hand every month.

0 XP

Step 1 of 6 · 1 point

Line totals are in column J. In K2, return "Bonus" if the order is over 1000 and "No" if it is not.

ABCDEFGHIJ
1OrderIDDateBranchRepCategoryProductQtyUnitPriceDiscountLineTotal
240012026-01-05FairviewPriya RaghavanElectricalRomex 12-2 250ft4148.000.1532.80
340022026-01-05FairviewPriya RaghavanElectricalRomex 12-2 250ft5148.000740.00
440032026-01-06NorthgateMarcus ElleryPaintWood primer, 1gal246.750.0588.83
540042026-01-07NorthgateMarcus ElleryPlumbingBall valve 1/2in19.250.058.79
640052026-01-07BrooksideDanielle OkaforPlumbingCopper pipe 1/2in 10ft131.40031.40
740062026-01-08BrooksideDanielle OkaforPlumbingCopper pipe 1/2in 10ft131.40031.40
840072026-01-08BrooksideDanielle OkaforPaintInterior latex paint, 5gal3138.000.05393.30
940082026-01-08BrooksideDanielle OkaforToolsCordless drill 18V5209.000.1940.50
1040092026-01-09FairviewPriya RaghavanPlumbingBall valve 1/2in39.25027.75
1140102026-01-09NorthgateMarcus ElleryPaintRoller and tray set614.20085.20
1240112026-01-09BrooksideDanielle OkaforPlumbingWater heater element 4500W624.100144.60
1340122026-01-10NorthgateMarcus ElleryToolsCordless drill 18V1209.000209.00
1440132026-01-10NorthgateMarcus ElleryPlumbingCopper pipe 1/2in 10ft431.400.05119.32
Rows 1 to 14 of 315
K2fx