Closed Thread
Results 1 to 4 of 4

Automatically Distributed Values

  1. #1
    Forum Contributor
    Join Date
    07-26-2016
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    117

    Automatically Distributed Values

    Hello!

    I am working on a template that I am currently using to automatically distribute the total number of points to the number of meetings.

    Here are the steps:
    1.The user will encode the total number of points that will be automatically distributed.
    2. The user will encode the number of meetings.

    As the user encodes the number of meetings, excel will automatically assign how many points will be allotted for each meetings (I already have a working formula for this). I need to modify this formula in such a way that I would like to automatically subtract 9 from the total number of points so that only the difference will be distributed for each meetings.
    Attached Files Attached Files
    Last edited by Simply_Me; 10-06-2021 at 12:24 AM.

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Need help with my formula

    Most people who ask questions here, need help with a formula - your title does nothing to describe what your actual question/problem is.

    We would very much like to help you with your query, however the thread title does not really convey what your request is about. Tell us what you are trying to do, not how you think it should be done.

    Please take a moment to amend your thread title. Make sure that the title properly explains your request. Your title should be explicit and not be generic (this includes function names used without an indication of what you are trying to achieve).

    Please see Forum Rule #1 about proper thread titles and adjust accordingly. To edit the thread title, open the original post to edit and then click on Go Advanced (bottom right) to access the area where you can edit your title.

    (Note: this change is not optional. No help to be offered until this moderation request has been fulfilled.)
    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

  3. #3
    Forum Contributor
    Join Date
    07-26-2016
    Location
    Philippines
    MS-Off Ver
    2016
    Posts
    117

    Re: Need help with my formula

    Thank you for your reply sir and I am sorry that I posted this in the wrong forum, It should be in General Excel. I already posted it the proper forum, so I will be deleting this thread here.

  4. #4
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 7/10/13/16/365 (PC ver 2310)
    Posts
    52,917

    Re: Automatically Distributed Values

    OK thanks for the update, I will close this 1.

    For future reference, there is no need to start a new thread if you think you posted in the wrong forum. Just ask (in that thread) for a mod to move the thread for you

Closed Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Replies: 3
    Last Post: 03-24-2020, 07:27 AM
  2. Replies: 3
    Last Post: 01-10-2019, 09:34 AM
  3. Replies: 5
    Last Post: 02-16-2018, 06:50 AM
  4. Replies: 8
    Last Post: 09-22-2017, 05:41 AM
  5. Excel formula bar to display the result of the formula , not the formula?
    By max_max in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-18-2016, 07:15 PM
  6. Replies: 11
    Last Post: 06-06-2014, 03:34 PM
  7. how to hide formula in formula box, view lookup result in formula box?
    By vengatvj in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 10-14-2013, 04:06 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