+ Reply to Thread
Results 1 to 4 of 4

Need Cap (limit max or minimum function code) calculation tip

  1. #1
    Registered User
    Join Date
    09-05-2020
    Location
    sharjah
    MS-Off Ver
    2010
    Posts
    2

    Question Need Cap (limit max or minimum function code) calculation tip

    hi,

    I am looking for a solution to below problem.

    NORMAL SCENARIO , SHARE 1 GETS 80% AND SHARE 2 GETS 20%

    type TOTAL SHARE 1 SHARE 2
    A 100 80 20
    B 100 80 20
    C 100 80 20
    D 100 80 20
    Total 400 320 80

    PROBLEM SCENARIO SHARE 2 GETS 20% BUT UPTO MAXIMUM 50, SHARE 1 GETS REST ALL

    type TOTAL SHARE 1 SHARE 2
    A 100 80 20
    B 100 80 20
    C 100 90 10
    D 100 100 0
    Total 400 350 50

    HOW TO CODE IF I HAVE TO FIX TOTAL SHARE OF SHARE 1 OR SHARE 2 TO A FIXED AMOUNT (FOR EXAMPLE 10% MAX 20, 80% MAX 200)
    Last edited by AliGW; 09-05-2020 at 05:19 PM. Reason: Urgency statement removed.

  2. #2
    Banned User!
    Join Date
    02-06-2020
    Location
    Iowa City, IA, USA
    MS-Off Ver
    2016 - 365 / 2007
    Posts
    2,014

    Re: Need Cap (limit max or minimum function code) calculation tip

    first of all, saying that you need urgently won't probably get you much help. secondly, when you said this:
    Quote Originally Posted by whosayin View Post

    PROBLEM SCENARIO SHARE 2 GETS 20% BUT UPTO MAXIMUM 50, SHARE 1 GETS REST ALL

    type TOTAL SHARE 1 SHARE 2
    A 100 80 20
    B 100 80 20
    C 100 90 10
    D 100 100 0
    Total 400 350 50
    I take that to mean that you want SHARE 2 to be a variable value, whereby you put ''x'' percent into it, and then the difference (to make a total of 100%) into SHARE 1. correct? If that's what you want to do, all you need to put in the column where SHARE 1 data resides, is a simple subtraction formula.

  3. #3
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Business (Win 10 - Work) & MS 365 Subscription Insider (Win 10 - Home)
    Posts
    46,843

    Re: Need Cap (limit max or minimum function code) calculation tip

    It doesnít matter how urgent your requirements are. The help you get here will be for free and offered as and when a member feels they are able to help. If you canít wait, you would be better subscribing to a paid services that runs 24/7. Thank you for your patience.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!

    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.
    Don't forget to say "thank you" to those who have helped you in your thread. If you wish, you can also reward them by clicking on their reputation star bottom left.

  4. #4
    Registered User
    Join Date
    09-05-2020
    Location
    sharjah
    MS-Off Ver
    2010
    Posts
    2

    Re: Need Cap (limit max or minimum function code) calculation tip

    Thanks for reverting,

    i have tried a bunch of formulas but no avail, what i need is that if there is a limit value for a total share 1 can avail then the rest of the raw's calculation should also be adjusted.

    i.e. if the share 2 is 10% with maximum 10 then if the first line with type 1 will calculate share to as 10 (10% of 100) but as now the limit in total for share to is reached (10 is maximum he can avail) so calculation should stop and not go to type B, then type C and then type D

+ 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. [SOLVED] How to limit a userform textbox to a minimum of 18 characters?
    By danbates in forum Excel General
    Replies: 2
    Last Post: 11-06-2017, 09:25 PM
  2. [SOLVED] Fix minimum date calculation
    By vio.coman in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 12-21-2016, 09:21 AM
  3. [SOLVED] Need to Limit the Sum of a list of values to a Minimum and Maximum Value
    By Joe Ziolkowski in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-13-2016, 07:19 AM
  4. the maximum and minimum limit
    By madhupangal in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 12-07-2015, 05:49 PM
  5. [SOLVED] How would I modify calculation to have value = zero (0) after reaching a minimum.
    By Jim15 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 07-18-2013, 02:14 PM
  6. Excel 2007 : Minimum Taxes Calculation Worksheet
    By jwillis76 in forum Excel General
    Replies: 3
    Last Post: 01-12-2011, 11:42 AM
  7. Formula to limit the minimum waste
    By Krazy_Kaos in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 09-27-2007, 04:59 AM

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