Spotlight Video Rentals Spotlight Video is a company which uses automated retail kiosks to rent the latest selections of DVDs, and Blu-ray. After they have been viewed a certain number of times, their quality deteriorates to the point that Spotlight Video considers them to be defective. Furthermore, some customers own media players that are defective and can ruin Spotlight Video's merchandise. Spotlight Video wants to maintain an inventory of DVDs and Blu-ray media that are at least 85 percent acceptable, although 95 percent is preferable. However, since it can't keep customers' machines from damaging the rentals, Spotlight Video has had to relax its criterion a little. This spreadsheet will help evaluate each rental, based on the following criteria:

Number of times each title has been rented.

Number of defects that have been reported.

The percent acceptable must be above 85 percent based on usage. If the percentage reported is below 85 percent, then Spotlight Video wants to flag this video as "REPLACE." Spotlight Video has provided you with the data in a file called T4_SpotlightVideo_Data. xlsx. I am suppose to create an IF function to write a conditional expression that examines the criteria mentioned above. Figure T4.18 displays a sample of the output that Spotlight Video needs. i need help figuring out the formulas and how to answer this problem in excel. Any help would be great thanks.

Here is the Data Below:

Here is a pic of sample Figure T4.18 below: