Excel Formula Help

Hi @everyone, I would please like some with a formula. I'm taking an online course on Excel and was presented with a practice challenge, I couldn't quite figure out how to answer the question so I lo...