Quizzes & Puzzles0 min ago
Is Anyone On Here Good At Excel 2013?
8 Answers
Enter a formula that uses an IF function and structured references to determine customer discount eligibility. (Hint: You will need to use the OR function in this formula.)
a. A customer is eligible for a discount if the value in a customer’s 2016 Purchases is greater than or equal to $250 OR if the customer’s First Order was placed before 2012.
b. If the customer qualifies for a discount, return a value of Y. (Hint: For the value_if_true value, use “Y”.)
c. If the customer does not qualify for a discount, return a value of N. (Hint: For the value_if_false, use “N”.) If necessary, copy the formula you created in cell K4 to the range K5:K27.
a. A customer is eligible for a discount if the value in a customer’s 2016 Purchases is greater than or equal to $250 OR if the customer’s First Order was placed before 2012.
b. If the customer qualifies for a discount, return a value of Y. (Hint: For the value_if_true value, use “Y”.)
c. If the customer does not qualify for a discount, return a value of N. (Hint: For the value_if_false, use “N”.) If necessary, copy the formula you created in cell K4 to the range K5:K27.
Answers
Best Answer
No best answer has yet been selected by Elena_W. Once a best answer has been selected, it will be shown here.
For more on marking an answer as the "Best Answer", please visit our FAQ.Presume this is part of some Excel course homework!
So, assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 should produce the result desired:-
=IF(OR(D4>=250,B4
So, assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 should produce the result desired:-
=IF(OR(D4>=250,B4
Trying again, last post lost some of the info!
Presume this is part of some Excel course homework!
So, assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 would produce the result desired:-
=IF(OR(D4>=250,B4
Presume this is part of some Excel course homework!
So, assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 would produce the result desired:-
=IF(OR(D4>=250,B4
Again,
Presume this is part of some Excel course homework!
So, assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 would produce the result desired:-
'=IF(OR(D4>=250,B4
Presume this is part of some Excel course homework!
So, assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 would produce the result desired:-
'=IF(OR(D4>=250,B4
Nope, AB completely messed up my formula as well!
Here it is as an image:
http:// s7.post img.org /3w91lk y8r/for mula1.j pg
Hopefully it makes sense from there.
Here it is as an image:
http://
Hopefully it makes sense from there.
Yes, Aquariel AB, post doesn't like the 'less than' symbol in the post, it chops everything off when it sees it! Your formula is correct but it is missing the date 2012 check.
Trying again, and if it doesn't post correctly this time I'm giving up!
So my formula post minus the 'less than' symbol, but replaced with the @ symbol is:
Assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 would produce the result desired:-
'=IF(OR(D4>=250,B4@DATE(2012,1,1)), "Y","N")'
(need to change the @ character for the 'less than' symbol i.e. the keyboard character that points opposite to the > symbol
If that works ok, you can then copy and paste the formula into the cells K5:K27, which presumably will be used for checking other customers records that follow the first customer record row at 4 i.e. rows 5 through to 27.
Trying again, and if it doesn't post correctly this time I'm giving up!
So my formula post minus the 'less than' symbol, but replaced with the @ symbol is:
Assuming the Total Sales figure for a specific customers 2016 purchases is located at cell reference D4 and their first order date is located in cell B2, then the entering the following formula into cell K4 would produce the result desired:-
'=IF(OR(D4>=250,B4@DATE(2012,1,1)), "Y","N")'
(need to change the @ character for the 'less than' symbol i.e. the keyboard character that points opposite to the > symbol
If that works ok, you can then copy and paste the formula into the cells K5:K27, which presumably will be used for checking other customers records that follow the first customer record row at 4 i.e. rows 5 through to 27.
Related Questions
Sorry, we can't find any related questions. Try using the search bar at the top of the page to search for some keywords, or choose a topic and submit your own question.