In Sheets, with amount in column D, type the row-2 formula that labels an order "Large" at $500 or more and "Small" otherwise.
In Sheets, with amount in column D, type the row-2 formula that labels an order "Large" at $500 or more and "Small" otherwise.
Answer
=IF(D2>=500, "Large", "Small")
Condition, value if true, value if false. Text results must be quoted. Filled down: 5 Large, 7 Small.