Nested IFs, ORs and ANDs in Excel

I'm new to excel and this is confusing me. I am trying to solve the following problem with a nested IF statement and I'm unable to figure it out:

Make sure the Valuable worksheet is active and enter a logical function in the comments column to display Highly Valuable if either condition is met:

- The release date is on or before December 31, 1989 or
- The sold-out status is YES, the percentage increase in value is at least 500%, or the Edition Size was less than 400

Enter an empty text string if the conditions are not met. hint: You need to nest two logical functions within the logical test argument. Use cell references to the two conditions.

Knowing all this, I'm a little confused on how:

• To write this big IF statement
• Display (or keep hidden) Highly Valuable

My spreadsheet would be the following:

Any help would be highly appreciated.

Thank you.