in cell L2 in the valuable worksheet, enter a nested logical function to display highly valuable if either condition is met:
-the release date is on or before December 31,1994 or
-the sold out status is yes, the percentage increase in value is at least 500%, and the edition size was less than 700
enter an empty text string if the two conditions are not met
you need to nest two logical functions within the logical test argument. use cell references to set all conditions. copy the function from cell L2 to range L3:L40
Solved by O. H. in 21 mins