need an excel formula expert

Closed - This job posting has been filled.

Job Description

I am trying to create an excel file and Im having trouble with "layerd" percentages. Here's an example scenario:

1,000 people go to a website.

10% of those people buy product 1 for $50

7% of the people who bought product 1 then buy product 2 for $20.

3% of the people who bought product 2 then buy product 3 for $500.

What is the maximum amount a marketer would have to pay PER website visitor before losing money?

The number is $5.245

But I can't get the formulas setup to calculate this. This might also evolve into a bigger project.