Help on nesting logical function

[jotran5]

Doing a chapter 7 capstone e07m2art (1).xlsx

Question: make sure the valuable sheet is active and enter a nested logical function in the Comments column to display Highly Valuable if either condition is met:
1. the release date is on or before December 31, 1989 or 2. The sold-out status is Yes, the percentage increase in value is at least %500, and the issue size was less than 400

[judgeh59]

this may work....I'm not sure which column was "issue size" so I chose "Edition Size"

Please Login or Register  to view this content.

[TMS]

If this is homework, how do you benefit from someone on the forum answering the question for you?

As a hint, you will use OR for conditions 1 and 2 and you will use AND for the sub-conditions in condition 2.

Regards, TMS

[jotran5]

The title of this thread doesn't say "Hey! Give me the answer for this question." I wasn't looking for a straight answer, I was actually hoping to see if somebody on this forum was going to explain how to do it. I didn't post up all the questions from the capstone, it was just one question.

[jotran5]

How did you get 32873?

[judgeh59]

Did my answer work?

32873 is the actual XL date for 12-31-1989

[judgeh59]

32873 is the actual XL date for 31/12/1989 OR 32873 days from 1/1/1900

HTH

[TMS]

I wasn't looking for a straight answer, I was actually hoping to see if somebody on this forum was going to explain how to do it.

And that is what you got ...

... you will use OR for conditions 1 and 2 and you will use AND for the sub-conditions in condition 2.

There again, you were given the answer, ahead of the hint, so I guess you'll just copy that out.

I hope you get good marks for your coursework ... and that you will be able to apply that knowledge effectively in the future

[TMS]

Rather than using 32873, you could use:

Please Login or Register  to view this content.

or

Please Login or Register  to view this content.

which makes it a little bit more obvious what the number relates to.

Regards, TMS

[judgeh59]

I guess I didn't know Chapter 7 Capstone was coursework....here in the Colonies Chapter 7 is a type of bankrupcy...If I had knows that it was coursework would've still helped but probably just given really good hints (I hope)....also, I wouldn't mind a rep star (*)...if you think I was helpful....

[judgeh59]

I completely forgot about those two.....thanks TS

[woodstocksnoopy1967]

In cell M9, enter a database function to average the estimated values (Est. Value) of highly valuable pieces of artwork indicated in column J. Use the criteria in cells P2:P3 in your function.

[lulubutter7]

where did the 32873 come from because I plugged it in and your right but i just wanted to know where the 32873 comes from

[AKEEMBAE]

when they ask for a data base function is it that counts the number of something. its Datacount and not countif correct?

[Pete_UK]

Is there much use in responding to a thread which was started 5 years ago?

Pete

[FDibbins]

Probably should quote the "hijacking" rule for this, but anyway...

where did the 32873 come from because I plugged it in and your right but i just wanted to know where the 32873 comes from

What you need to understand about dates and times in excel is…

a date is just a number representing the number of days passed since 1/1/900...and then formatted in a way that we recognize as a date. So, for instance, today (Thu 28 Feb 2019) is actually 43524

Time is actually a decimal part of 1 (day), so 06:00 AM is 0.25, 12 noon is 0.5 and 18:00 (or 6 PM) is 0.75

32873 is how many days have passed since 1/1/1900 - which gets you to 12/31/1989

[FDibbins]

when they ask for a data base function is it that counts the number of something. its Datacount and not countif correct?

Who are "they" and why are they asking? And no, that is not correct. But to get a better answer, Unfortunately your post does not comply with Rule 4 of our Forum RULES. Do not post a question in the thread of another member -- start your own thread.

If you feel an existing thread is particularly relevant to your need, provide a link to the other thread in your new thread.

Old threads are often only monitored by the original participants. New threads not only open you up to all possible participants again, they typically get faster response, too.