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/