Results 1 to 21 of 21

Hello! Please could you tell me how much I should spend to buy balls?

Threaded View

  1. #1
    Registered User
    Join Date
    08-19-2023
    Location
    Foggia, Italy
    MS-Off Ver
    Microsoft 365 for enterprise
    Posts
    7

    Hello! Please could you tell me how much I should spend to buy balls?

    Hello,

    I will try to explain my problem with an example. I want to buy 10 balls in a shop, spending the minimum money amount. In this shop, there are 2 balls at 1?, 3 balls at 2?, 4 balls at 3?, 4 balls at 5?, ..., 2 balls at 100?.
    I want to know how much is the minimum that I should spend to buy these 10 balls.

    Manually, I know that I have to spend 2*1?+3*2?+4*5?+1*5?=33?, but I don't know how to put this in an Excel Formula.
    I have the number of balls for each price (from 1 to 100) in the column A1:A100. Column B could be the price (simply the sequence of numbers from 1 to 100). Obviously, I would have a solution not only for 10 balls but for n balls.

    Could someone help me?

    Thank you very much in advance,

    Maurizio_V
    Attached Files Attached Files
    Last edited by Maurizio_V; 08-19-2023 at 09:46 PM.

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Distributing 30 coloured balls into 5 tubs with conditions
    By excelnoob32 in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-02-2021, 10:28 AM
  2. Replies: 4
    Last Post: 05-04-2020, 06:33 AM
  3. Reduce games from 18 balls to 16 balls
    By rafa.jsilva in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 11-19-2019, 09:58 AM
  4. Arrange balls in bins
    By amanratan in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-26-2015, 05:51 PM
  5. Spend Analysis
    By spearse in forum Excel General
    Replies: 1
    Last Post: 04-07-2015, 02:43 PM
  6. Cricket Stats - Balls Bowled
    By softz in forum Excel General
    Replies: 7
    Last Post: 07-08-2009, 08:40 PM
  7. [SOLVED] How do I estimate the year spend if spend is $26000 as of May?
    By Felicia Pickett in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 06-19-2006, 11:15 PM

Tags for this Thread

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