Task #20

Customer tier

A store groups customers by how much they spent in a year:

  • $1,000 or more: "Gold";
  • $500 or more: "Silver";
  • everyone else: "Bronze".

Find each customer's tier in C2:C9.

Task #20
Customer tier

A store groups customers by how much they spent in a year:

  • $1,000 or more: "Gold";
  • $500 or more: "Silver";
  • everyone else: "Bronze".

Find each customer's tier in C2:C9.