Need help with a spreadsheet!

%3CLINGO-SUB%20id%3D%22lingo-sub-2012780%22%20slang%3D%22en-US%22%3ENeed%20help%20with%20a%20spreadsheet!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2012780%22%20slang%3D%22en-US%22%3E%3CP%3EHi%20All%2C%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20not%20sure%20how%20to%20clearly%20explain%20what%20I%20am%20trying%20to%20do%20so%20I'll%20do%20my%20best%20in%20this%20message%20and%20I've%20attached%20a%20file%20to%20review.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20am%20trying%20to%20build%20a%20spreadsheet%20to%20analyze%20a%20website's%20revenue%20related%20to%20its%20users%20and%20conversion%20rate.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIf%20the%20Users%20go%20up%20or%20down%20how%20does%20the%20Conversion%20Rate%20need%20to%20adjust%20to%20compensate%20and%20vice%20versa%20in%20order%20for%20the%20site%20to%20generate%20%2410M%20in%20sales%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI'm%20really%20stuck%20so%20I'd%20greatly%20appreciate%20your%20help!%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHappy%20Holidays%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ECheers%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EGavin%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2012780%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2013162%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20a%20spreadsheet!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2013162%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F910458%22%20target%3D%22_blank%22%3E%40gcaganoff%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESee%20the%20attached%20version.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2015220%22%20slang%3D%22en-US%22%3ERe%3A%20Need%20help%20with%20a%20spreadsheet!%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2015220%22%20slang%3D%22en-US%22%3E%3CP%3EVeel%20dank%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F127945%22%20target%3D%22_blank%22%3E%40Hans%20Vogelaar%3C%2FA%3E%26nbsp%3B!%20I%20lived%20in%20Amsterdam%20for%20a%20couple%20of%20years%20back%20in%202001%20so%20I%20know%20a%20little%20Dutch%20%3A).%20You%20really%20pulled%20me%20out%20of%20a%20hole%20of%20frustration!%20Happy%20holidays%20to%20you%20and%20your%20loved%20ones%3F%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20Eileen's%20lounge%20a%20message%20board%20for%20help%20on%20Microsoft%20products%3F%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

Hi All,

 

I'm not sure how to clearly explain what I am trying to do so I'll do my best in this message and I've attached a file to review.

 

I am trying to build a spreadsheet to analyze a website's revenue related to its users and conversion rate.

 

If the Users go up or down how does the Conversion Rate need to adjust to compensate and vice versa in order for the site to generate $10M in sales?

 

I'm really stuck so I'd greatly appreciate your help!

 

Happy Holidays

 

Cheers

 

Gavin

4 Replies

@gcaganoff 

See the attached version.

Veel dank @Hans Vogelaar ! I lived in Amsterdam for a couple of years back in 2001 so I know a little Dutch :). You really pulled me out of a hole of frustration! Happy holidays to you and your loved ones?

 

Is Eileen's lounge a message board for help on Microsoft products? 

 

 

 

@gcaganoff 

https://www.eileenslounge.com is a discussion board with forums about each of the Office/Microsoft 365 applications, but also about Windows and about other applications. It is very friendly.

Thanks again @Hans Vogelaar. Happy new year!