Mini $2$ in the U$.$S$.$

Provide the promotional offer information for Benicio as follows.

a$.$ In cell G$5,$ start to enter a formula using the AND function and structured references.

b$.$ The first condition tests whether the value in the Product column $([$@Product$]$ equals "Mini $2",$ the product eligible for the promotional offer.

c$.$ The second condition tests whether the value in the Location column $([$@Location$])$ equals $"$U$.$S$.",$ the location eligible for the promotional offer.

d$.$ If Excel does not fill the column, fill the range G$6$: G$40$ with the formula in cell