+ Reply to Thread
Results 1 to 5 of 5

Formula for greater than or equal to

  1. #1
    Registered User
    Join Date
    05-08-2009
    Location
    Madison, WI
    MS-Off Ver
    Excel 2007
    Posts
    3

    Formula for greater than or equal to

    How do I write a formula whereas the end result is capped at a certain percentage.

    For example:

    =d13*(1+b14), the solution to that part of the formula cannot be greater than d4. I am very new at this, I know how to do the math but not create the formula

    15000 * 1 plus the percentage = x but cannot be greater than y and if is a negative number cannot be less than 0

    Any help would be greatly appreciated

  2. #2
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Formula for greater than or equal to

    a combination of MIN & MAX perhaps ?

    =MAX(0,MIN(D4,D13*(1+B14)))

  3. #3
    Registered User
    Join Date
    05-08-2009
    Location
    Madison, WI
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula for greater than or equal to

    d13*(1+b14)
    40000*1.1953=47812
    Anytime b14 is greater than d4 it should multiply by d4 which in this case is 7%. Also if b14 is a negative # the anser always has to equal zero.

    When I inputed your formula my output was .07 but it should be 42800
    40000*1.07

    Any ideas on what I am doing wrong

  4. #4
    Forum Guru DonkeyOte's Avatar
    Join Date
    10-22-2008
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    21,528

    Re: Formula for greater than or equal to

    Maybe it's be but it's not very clear what you want to do re: -ve %... whether entire result should be 0 or the multiplication should simply be 1 ?

    Perhaps you want:

    =D13*(1+(MAX(0,MIN(B14,D4)))

  5. #5
    Registered User
    Join Date
    05-08-2009
    Location
    Madison, WI
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: Formula for greater than or equal to

    Thank you very much, your second formula did the trick. I would have never figured this out on my own. I appreciate you taking the time to help me

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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