Question: 2 . 4 Complete the Discount? column. a . Use the IF function with an OR function as part of the criteria argument in cell

2.4 Complete the "Discount?" column.
a. Use the IF function with an OR function as part of the criteria argument in cell L5).
b. Return Yes if either "Savings Account?" (cell G5) or "AutoPay?" (cell H5) are listed as YES.
c. Otherwise, return "Suggest AutoPay" (without the quotes).
d. Copy your function down to complete the "Discount?" column.
2.4 Complete the "Discount?" column. a. Use the IF function with

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Databases Questions!

Q:

EX 802 Excel Chapter&Creating, Sorting and Querying a Table 1. Open the workbook Lab 6-1 City Market. Save the workbook using the file nar 2. Create three new calculated columns, Shelf Life, Days...

Q:

SUBJECT IS MICROSOFT EXCEL NO IDEA WHERE TO PUT THIs IM SORRY The grade column will requre you to create a lookup table area, shown in Table 6-6. Type the heading Grade table in cell J1 and fill in...

Q:

1.4 Complete the "Discount?" column. Use the IF function with an OR function as part of the criteria argument in cellL5. Return Yes if either "Savings Account?" (cellG5) or "AutoPay?" (cellH5) are...

Q:

Can someone please guide me through the last question titled Exercise 2 going for 2 where you have to use the AND OR and ABS formulas I can't wrap my head around doing it. MIS 204 - Lab 3 This lab...

Q:

Question Description The city market wants an easier way to keep track of fresh vegetables and their shelf life. Your format and summarize the data: PUSC THE F A Al @ + DADFERE 8 1 5 FFFFER 5 0 0 2...

Q:

Please complete & make into excel file please! Start from top to bottom! Thank you! Flexible Budget Performance Report Project Kelsey's Frozen Confectionaries buys and distributes single-serve ice...

Q:

im so confused please help i included ALL of the instructions given. which part is insufficent, i will add more B D F G H 2 E Flexible Budget Performance Report Project 3 4 Kristin's Frozen...

Q:

Please format into excel please ASAP! Flexible Budget Performance Report Project Kelsey's Frozen Confectionaries buys and distributes single-serve ice cream treats to convenience stores, ballparks,...

Q:

Creating Structured References, a Lookup Table, and a Treemap Problem: The City Market wants an easier way to keep track of the shelf life of fresh vegetables. You will format and summarize the data...

Q:

The city market wants an easier way to keep track of fresh vegetables and their shelf life. Your format and summarize the data: 1. Open the workbook Lab 6 1 City Market. Save the workbook using the...

Q:

Nafth Company has an Equipment Services Department that performs all needed maintenance work on the equipment in the company's Fabrication and Assembly Departments. Costs of the equipment Services...

Q:

PetCare Supplies Inc., a pet wholesale supplier, was organized on May 1, 2014. Projected sales for each of the first three months of operations are as follows: May ......$ 126,000 June ......145,000...

Q:

A trade union is pressing for a wage rise for its members. Which of the following would increase its chances of being successful? A An increase in productivity B An increase in unemployment C A...

Q:

Compared with half a century ago, adoption has become _ _ _ _ _ _ _ _ _ common, but it is more open and acceptabl e , so we probably discuss it _ _ _ _ _ _ _ . fill in the blanks more or much less or...

Q:

KEY QUESTION Use graphical analysis to show the gains and losses resulting from the migration of population from a low-income country to a high-income country. Explain how your conclusions are...

Q:

Assume that the graph depicts the U.S. domestic market for corn. How many bushels of corn, if any, will the United States export or import at a world price of $1, $2, $3, $4, and $5? Use this...

Q:

What is offshoring of white-collar service jobs, and how does it relate to international trade? Why has it recently increased? Why do you think more than half of all the offshored jobs have gone to...