Results 1 to 9 of 9

Min of Positive Values

Threaded View

  1. #1
    Registered User
    Join Date
    04-05-2009
    Location
    North Carolina, USA
    MS-Off Ver
    Excel 2003 & excel 2007
    Posts
    14

    Min of Positive Values

    I want cell D5 to be the minimum value of cells D29:T29. Some of the cells will have no value (or $0.00) and some will have values in them. I tried the following formula in cell D5 but it doesn't work: =IF(D29:T29>0,MIN(D29:T29))).

    Thanks
    Last edited by Edward C; 07-23-2009 at 09:13 AM. Reason: Solved....thank you very much

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