Finding best formula in Excel to count for my case

Hello. I cannot solve this mathematical problem: Let’s say I have 5 cells. Each of them represents one unique item to buy. I have placed prices of these items in these cells . Some of them have the same price. In another cell I have money budget. For example: I have budget $1000.

  1. item costs $500
  2. item costs $150
  3. item costs $200
  4. item costs $200
  5. item costs $50

I need to count automatically how big is a maximum number of how many another items I can buy simultaneously if I buy an item from the 1st cell. That count I need to duplicate for every item in list. Also every item has different budget. It’s not important why it is so but that’s a fact. My research to find a useful formula was useless. My attempts to figure out which formula I should use were unsuccessful too. The example is demonstrative. The final result will be more complex and with many more cells. Thank you for quick response and I wish Merry Christmas & a Happy New Year 2017 to everybody here!

Explorer Asked on 25th December 2016 in Excel for Windows.
Add Comment
  • 3 Answer(s)

    Cant really figure out what you are trying to ask….

    Explorer Answered on 27th June 2017.
    Add Comment

    I need to cutting edge counts utilizing exceed expectations reports and I need a correct book or course that encourages the equation composing from scrach to top dimension with the goal that I can consider myself.

    Explorer Answered on 12th December 2018.
    Add Comment

    You can get the best formula in the count of fiction parts that were available at Excel this happened only in my case. I need to get known the solution so I join EduBirdie they have some professionals on it that will work along with all skills that were good to get over on it.

    Explorer Answered on 19th November 2019.
    Add Comment
  • Your Answer

    By posting your answer, you agree to the privacy policy and terms of use.