need an excel formula expert

Admin Support Data Entry Posted 2 years ago

Fixed Price

Budget: $30
Delivery by March 21, 2014

Start Date

March 21, 2014

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.

  • Other Skills:

Activity on this Job

Last Viewed by Client: 2 years ago

Hired: 1


About the Client

(5.00) 7 reviews

United States
Albertville 06:39 AM

20 Jobs Posted
50% Hire Rate, 1 Open Job

$457 Total Spent
10 Hires, 0 Active

Member Since Jan 22, 2012