Hi there,
I have this conversion rate:
2/6 x 100 = 33% - which is 2 sales/6 clicks = 33% conversion rate
How would I devise a formula that worked backwards i.e. if I enter 33% into a cell, I want it to work backwards and figure out that means 2 sales. It's driving me mad please help!Any help would be very much appreciated.
Cheers,
Michelle
try this...
=33%/23/100*6
1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
2. If your question is resolved, mark it SOLVED using the thread tools
3. Click on the star if you think someone helped you
Regards
Ford
Whoops... forgot to add, the percentage will be located at cell D8. So I'll type in the % at D8 (33% or other) and have the formula calculated to another cell. Hope that makes sense.
How about
=ROUND(D8*6,0)
I think people forget the word "THANK YOU!!!!" Do you still know it???
There is a little star ( ADD REPUTATION ) below those person who helped you. Click it to say your "PRIVATE APPRECIATION TO THEIR EFFORT ON THEIR CONTRIBUTIONS "
Regards,
Vladimir
change it to....
=D8/23/100*6
Thanks FDibbins,
Ahhh... 33%/100x6 gives me the right answer. How do I enter that into excel if I want to change 33% to the cell D8, i.e. D8/100x6? Sorry for my dumb question, I'm NOT a big excel user! Also, is there a way to make excel round the number to the nearest whole number as I don't want decimals. Many thanks!
Cheers,
Michelle
Ohh.. you guys both rock! Thank you so much... just saw your reply vlady, perfect!
Cheers,
Michelle
glad to help. it would be appreciated if you would thank those who helped you by clicking on the star on the lower left of the post
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks