+ Reply to Thread
Results 1 to 5 of 5

How to do if greater than or equal to

  1. #1
    Forum Contributor
    Join Date
    06-11-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    How to do if greater than or equal to

    I have two numbers. I wish to produce a value in a cell that can only be equal to the sum of two cells A,B if it does not exceed the value in another cell Y, otherwise it can be A,B< or = Y.

  2. #2
    Forum Expert shg's Avatar
    Join Date
    06-20-2007
    Location
    The Great State of Texas
    MS-Off Ver
    2010, 2019
    Posts
    40,689

    Re: How to do if greater than or equal to

    =min(a+b, y)
    Entia non sunt multiplicanda sine necessitate

  3. #3
    Forum Contributor
    Join Date
    06-11-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: How to do if greater than or equal to

    I have =IF(S42< C43, S42, C43) but your way shows me that the cell will deliver either the minimum of a+b or y hmm pretty not bad ...

  4. #4
    Forum Contributor
    Join Date
    06-11-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: How to do if greater than or equal to

    I also need it to display a+b or y but right now it's just stating TRUE

  5. #5
    Forum Contributor
    Join Date
    06-11-2012
    Location
    Edmonton, Canada
    MS-Off Ver
    Excel 2010
    Posts
    124

    Re: How to do if greater than or equal to

    Make that, nevermind ... 15 hours of excel in a row makes for a weary daddy. Excel retained my last function in the cell but didn't display it in the ribbon. May be time for a reboot.

    Cheers,

+ 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