Question: Needing some help with my excel homework, needing help with the formula: Donors receive a premium as a token of appreciation if their donation is

Needing some help with my excel homework, needing help with the formula: Donors receive a premium as a token of appreciation if their donation is at the "Gold" level or they are repeat donors. Provide this information for Jane as follows: In cell K5, insert a formula using the OR function that returns TRUE if the donation level (cell H5) equals "Gold" or the repeat donor indicator (cell J5) equals "Y". Use the Fill Handle to fill the range K6:K17 with the formula in cell K5, filling the range without formatting.

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 Finance Questions!

1. a. PROJECT STEPS Jane Bahr is a development officer at Cortona University, a private university in western Massachusetts. She is tracking the pledges received from donors in July and August and...

PROJECT STEPS 1 . Jane Bahr is a development officer at Cortona University, a private university in western Massachusetts. She is tracking the pledges received from donors in July and August and...

Copy a tormula into a range. Jane sends a reminder to donors with pledges that have been overdue for more than 2 1 days if the amount is more than $ 8 0 0 . Provide a quick way to identify those...

Cortona University assigns each donation to a level of Gold, Silver, or Bronze depending on the pledge amount. Display the donation level using a nested IF function as follows: In cell H5, insert a...

Excel Donors receive a premium as a token of appreciation if their donation is at the "Gold" level or they are repeat donors. Provide this information for Jane as follows: In cell K5, insert a...

6 . Donors receive a premium as a token of appreciation if their donation is at the "Gold" level or they are repeat donors. Provide this information for Jane as follows: a . In cell K 5 , insert a...

Jane Bahari is a development officer at Sun Valley University, a private university in Kwazulu-Natal. She is tracking the pledges received from donors in July and August and analysing the gifts...

Kindly work on project 2 for me. This is very important to me as i hope to boost up my failing grade. Please no plagiarism. must be original. I have seen your work and know you will deliver. The...

I need Chapter 2 & 3 finished. Chapter 4 & 5, Chapter 6 & 7, & Chapter 8. Some of this is completed, but it isn't 100% finished. Let me know if you can get to it. Personal Finance, Fifth Edition by...

Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...

Class is ANT 2000 Into to Anthropology PLEASE ANSWER THE FOLLOWING QUESTION, THANKS!. Social Construct Essay Using one of the following anthropological concepts: race, gender, or kinship, explain the...

Construct a box plot for these data and identify any outliers: 25, 22, 26, 23, 27, 26, 28, 18, 25, 24, 12

Prepare journal entries to record the 2 0 2 2 transactions of Sunland Company. ( Credit account titles are automatically indented when the amount is entered. Do not indent manually. List all debit...

You are the marketing manager for Gatorade. You need to know about _ _ _ _ _ that is , how the consumer compares your competitive advantage relative to other brands to arrive at a purchase intention....

The cost of living in Mexicois substantially below that of Carters current locations. How would you go about developing a pay plan for your new manager if you decided to send an expatriate to Mexico?...

Present a detailed explanation of the factors you would look for in your candidate for expatriate manager to run the stores in Mexico. Afew years ago, Jack Carter took along vacation and Questions...

Assuming they began by opening just one or two stores in Mexico, what do you see as the main HR-related challenges Jack and Jennifer would have to address? Afew years ago, Jack Carter took along...