Results 1 to 4 of 4

Thread: min >0 (97 SR2)

  1. #1
    3 Star Lounger
    Join Date
    May 2001
    Location
    Berkeley, California, USA
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    min >0 (97 SR2)

    Is there a function that will return the Minimum value greater than zero from a range of cells?

  2. #2
    Star Lounger
    Join Date
    Dec 2000
    Location
    Tacoma, Washington, USA
    Posts
    68
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: min >0 (97 SR2)

    =MIN(IF(Range<>0,Range,FALSE)) this is an array formula. Enter using Ctrl+Shift+Enter
    Also see:
    http://www.cpearson.com/excel/lists.htm
    <IMG SRC=http://www.wopr.com/w3tuserpics/DougKlippert_sig.jpg>

  3. #3
    3 Star Lounger
    Join Date
    May 2001
    Location
    Berkeley, California, USA
    Posts
    214
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: min >0 (97 SR2)

    I got an error message. <img src=/S/bwaaah.gif border=0 alt=bwaaah width=123 height=15> I suppose i should have stated that the columns containing the datea to be evaluated are not adjacent.
    They are in $AE22,$AA22,$W22,$S22. I tried to substitute this in your formula surrounded by Parenthasies "($AE22,$AA22,$W22,$S22)" for the word "Range"

  4. #4
    Uranium Lounger
    Join Date
    Jan 2001
    Location
    South Carolina, USA
    Posts
    7,295
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: min >0 (97 SR2)

    You could do something like this:

    <pre>=MIN(IF(S22>0,S22,999999999999999),IF(W22>0,W 22,999999999999999),IF(AA22>0,AA22,999999999999999 ),IF(AE22>0,AE22,999999999999999))
    </pre>

    Legare Coleman

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •