+ Reply to Thread
Results 1 to 2 of 2

Formula for displaying in 1 cell Lowest value from multiple other cells

  1. #1

    Formula for displaying in 1 cell Lowest value from multiple other cells

    Does anyone know how to set this up?
    I have a worksheet with multiple columns. Each cell in these columns
    has a differnt value. I am looking for a formula to display in 1 cell,
    the lowest value from cells in the other 3 columns. I have heard of an
    "if" formaula, but can't find how to do this -
    Anyone able to help?
    Thanks- Doug


  2. #2
    Beege
    Guest

    Re: Formula for displaying in 1 cell Lowest value from multiple other cells

    Doug

    =MIN(A1:C200)

    Commit by shft-ctrl-enter (an array fomula)

    Beege

    <[email protected]> wrote in message
    news:[email protected]...
    > Does anyone know how to set this up?
    > I have a worksheet with multiple columns. Each cell in these columns
    > has a differnt value. I am looking for a formula to display in 1 cell,
    > the lowest value from cells in the other 3 columns. I have heard of an
    > "if" formaula, but can't find how to do this -
    > Anyone able to help?
    > Thanks- Doug
    >




+ 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