Shared Audio

Next, let's build the LastPrice column: if the item is Iced, add 200 to the price. The logic: if Hot, use UnitPrice as-is; if Iced, use UnitPrice + 200. First, check whether the Type in the same row is "Hot." Type = then click the Type cell, then type ="Hot" (capital H, everything else in half-width). Press Enter and copy down. You'll see TRUE where the item is Hot, and FALSE where it's Iced. TRUE means the condition matches; FALSE means it doesn't. Now we want to assign meaning to that True/