need an excel formula expert

Admin Support Data Entry Posted 1 year ago

Fixed Price

Delivery by March 21, 2014

$30.00

Budget

Details

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.

Skills Required:

Client Activity on this Job

Last Viewed: 1 year ago

Proposals: 46

Hired: 1


About the Client

(5.00) 7 reviews

United States
Albertville 12:16 AM

19 Jobs Posted
53% Hire Rate, 1 Open Job

$457 Total Spent
10 Hires, 0 Active

Member Since Jan 22, 2012