Is Anyone On Here Good At Excel 2013?

[Elena_W]

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.

[pinkyboyid]

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

[pinkyboyid]

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

[pinkyboyid]

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

[pinkyboyid]

Wow, AB post does not seem to want take all the text! so, hopefully here is the missing bits:-

[Aquariel]

I've had the same problem, pinkboyid!

Here's my version, see if it works...

=IF(OR(E8=250),"YES","NO")

Where E8 is first order date, F8 is order value.

[Aquariel]

Nope, AB completely messed up my formula as well!

Here it is as an image:
http://s7.postimg.org/3w91lky8r/formula1.jpg

Hopefully it makes sense from there.

[pinkyboyid]

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.

[Elena_W]

Thank you so much for the help guys!