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.