Go to the Current Sales worksheet, which contains a table listing sales data for January, 2022. To make it easy to refer to the data, the table has been renamed "Sales". Benicio wants to use the table data in formulas.
In column G, Benicio wants to indicate whether DIG Technology should send the customer a promotional offer. Customers are eligible for the offer if they purchased a Mini 2 in the U.S. Provide the promotional offer information for Benicio as follows:
a. In cell G5, 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 G6:G40 with the formula in cell G5.
Reading books is a great way to learn. Here are some of the books we recommend.
In Excel, the "AND" function is a logical function used to check if multiple conditions are true. It returns the value "TRUE" if all the conditions are met, and "FALSE" if any of the conditions are not met. It is typically used in conjunction with other functions or formulas to perform conditional calculations or determine if certain criteria are satisfied.
To solve the given question, click cell G5 and enter
=and([@Product]="Mini2",[@Location]="U.S.")Video instruction: