In cell l2 in the valuable worksheet enter a nested logical


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 the range L3:L40.

Solution Preview :

Prepared by a verified Expert
Business Management: In cell l2 in the valuable worksheet enter a nested logical
Reference No:- TGS02483350

Now Priced at $10 (50% Discount)

Recommended (98%)

Rated (4.3/5)