Question: Excel , need some help with the formula thank you in advance !! Clients are eligible for a discount if they have a rating of

Excel , need some help with the formula thank you in advance !!

  1. Clients are eligible for a discount if they have a rating of "A" or do not require an email reminder. Provide this information for Brett as follows:
    1. In cell J6, insert a formula using the OR function that returns TRUE if the rating (cell I6) equals "A" or the email reminder (cell H6) equals FALSE.
    2. Use the Fill Handle to fill the range J7:J15 with the formula in cell J6, 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 Accounting Questions!

Q:

Need help understanding how to correct my formulas based off the feedback to the instructions provided. I will list all the formulas I used that were marked as "incorrect. Please let me know if more...

Q:

Need help understanding how to correct my formulas based off the feedback to the instructions provided. I will list all the formulas I used that were marked as "incorrect. Please let me know if more...

Q:

a) b) please elaborate how you got this and please please please show what formula and steps you used to fill out the formula to get the answer. excel is still fairly new to me so im really trying to...

Q:

a) b) please do this in excel and elaborate which formula you used and what you put into the formual. im really struggling with this in excel, please help a sis out. thank you in advance! Pumpkin Inc...

Q:

1. Brett Thao is an insurance agent for the Great Midwestern Insurance in Milwaukee, Wisconsin. He is analyzing the invoices he has sent clients and the sales he generated in the third quarter of the...

Q:

1. Brett Thao is an insurance agent for the Great Midwestern Insurance in Milwaukee, Wisconsin. He is analyzing the invoices he has sent clients and the sales he generated in the third quarter of the...

Q:

Can anyone solve the answers from the given document givenbelow? I really need help. MY FINAL LITERALLY IS KNOCKING AT THE DOOR. Name_________________________________ Student...

Q:

SOMEONE PLEASE HELP ME GIVE ALL THE ANSWERS!!!!! MY EXAM IS ON 13th MORNING! SO PLEASEEEEE!!!!! 2. An investment is expected to pay the following: C 1 = $2,300, C 2 = $2,600, C 3 = $2,900, and then...

Q:

Can i please get help, here are the supporting documents needed for the initial questions . Thank you in advance At the time of the case in 2006, Terrence Conroy was contemplating the challenge of...

Q:

Please provide a maximum one-page summary of how we can analyze the cost of capital for our project (below) vis--visthe peer-reviewed research article attached. Consider risk as you decide. What...

Q:

What conclusion can be drawn regarding the rate of reaction of an alkyl bromide vs. an alkyl chloride? Is this conclusion in accord with theory regarding the SN2 mechanism?

Q:

A good description of the particular industry like ABC learning and how Corporate Governance might have played a part in the success of the business in relation with the following: How did the lack...

Q:

BPR indicates the redesign of business process to improve the organizational performance in terms of: a. Productivity b. Flexibility c. Quality d. None of these

Q:

Which of the following is NOT an input to the Cost Management Plan process? Group of answer choices Cost baseline Schedule baseline Project funding requirements Risk management plan

Q:

1 Do you agree with Doyle that the judgemental and developmental aspects of appraisal should not be combined? Doyle (2003) believes that, if a development appraisal is done well and it is linked to...

Q:

1 For the job you gathered information on in the activity for Chapter 7, review the requirements of the job and translate these into: (i) objectives; (ii) competencies.

Q:

Devise a 360- degree feedback process for your own position. 1 Who would be consulted? 2 What methods would be used (e. g. graphic rating scales, free narrative, etc.)? 3 Would the approach be...