Need Help with a formula

Hello.   I'm a real Excel (on a Mac) novice, although I can do some basic things. Here's the problem: How do I write a formula that will do the following:   I need help to create a new formula,...