+ Reply to Thread
Results 1 to 6 of 6

Formula to find number of candies

  1. #1
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    Office 365
    Posts
    425

    Formula to find number of candies

    Hi,

    Came across an interesting puzzle..
    was trying to find solution via Excel...

    You get three candies for 1$.And if you exchange three candy covers,you get an extra candy.
    So how many candies will you get in total for a price of 45$?



    Regards

  2. #2
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Formula to find number of candies

    45$ buys 135 bars

    trade the above at 3 wrappers per candy we get 45candies

    trade again we get 15 candies

    and again we get 5 candies

    and again we get 1 candy + 2 spare wrappers

    so we get a final 1 candy

    =202


    ????
    Last edited by JohnTopley; 01-07-2017 at 10:33 AM.

  3. #3
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    Office 365
    Posts
    425

    Re: Formula to find number of candies

    Hi John,
    Its the right answer!!
    However I was thinking if its possible to get the answer with the help of a formula

  4. #4
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,209

    Re: Formula to find number of candies

    I am no mathematician ...

    but we start with 5 and work "upwards" to 135 we have a geometric progression

    =5* (1-3^4)/(1-3)

    r=ratio : 3 in this case and 4 terms

    this gives a result of 200

    I don't know how you add the 1s (2 of them)!

  5. #5
    Valued Forum Contributor mahju's Avatar
    Join Date
    11-27-2010
    Location
    Pakistan, Faisalabad
    MS-Off Ver
    Excel 2010 plus
    Posts
    730

    Re: Formula to find number of candies

    You can use this formula in excel.

    Please Login or Register  to view this content.
    Where J5 has dollars

    Thanks
    Mark the thread as solved if you are satisfied with the answer.


    In your first post under the thread tools.

    Mahju

  6. #6
    Forum Contributor
    Join Date
    07-12-2015
    Location
    Dubai,UAE
    MS-Off Ver
    Office 365
    Posts
    425

    Re: Formula to find number of candies

    Quote Originally Posted by mahju View Post
    You can use this formula in excel.

    Please Login or Register  to view this content.
    Thanks
    Great!!
    Thank you so much

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Formula to find out number per 100
    By ExcelNub in forum Excel General
    Replies: 6
    Last Post: 05-27-2021, 12:19 AM
  2. Replies: 1
    Last Post: 10-07-2016, 02:16 PM
  3. formula to find a number
    By mindymaddox in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 03-22-2013, 10:26 AM
  4. Can`t find the reason for a number in my formula
    By Clarabella in forum Excel General
    Replies: 4
    Last Post: 07-06-2012, 11:18 AM
  5. Replies: 4
    Last Post: 02-26-2012, 02:38 AM
  6. Formula to find matching number
    By Jordans121 in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 02-21-2010, 11:18 PM
  7. Replies: 3
    Last Post: 07-07-2006, 09:10 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1