+ Reply to Thread
Results 1 to 3 of 3

Using Min function with cells in a Row returns incorrect result.

  1. #1
    Gaurav
    Guest

    Using Min function with cells in a Row returns incorrect result.

    I have some values in a row like (A5:G5)
    0.0035,0.0038,0.0029,0.0038,0.0022,0.0038,0.0038.
    In cell A8 I have formula =Min(A5:G5) and it gives me values 0.0038 instead
    of 0.0022.
    I am using Excel 2003.
    I have tried checking the format of the cells copying psting to a new work
    boomas values but no help
    In have even tried =Min(Transpose(A5:G5)) but no help.


  2. #2
    Niek Otten
    Guest

    Re: Using Min function with cells in a Row returns incorrect result.

    Try this

    Format an empty cell as number (just to be sure) and enter the number 1
    Edit>Copy
    Select your data, Edit>Paste Special, check multiply

    --

    Kind Regards,

    Niek Otten

    Microsoft MVP - Excel

    "Gaurav" <Gaurav @discussions.microsoft.com> wrote in message
    news:D4BF1495-6501-40F2-8BFF-0DC1384BE865@microsoft.com...
    >I have some values in a row like (A5:G5)
    > 0.0035,0.0038,0.0029,0.0038,0.0022,0.0038,0.0038.
    > In cell A8 I have formula =Min(A5:G5) and it gives me values 0.0038
    > instead
    > of 0.0022.
    > I am using Excel 2003.
    > I have tried checking the format of the cells copying psting to a new work
    > boomas values but no help
    > In have even tried =Min(Transpose(A5:G5)) but no help.
    >




  3. #3
    Gaurav
    Guest

    Re: Using Min function with cells in a Row returns incorrect resul

    Hi Neik,
    Thanks that worked.

    "Niek Otten" wrote:

    > Try this
    >
    > Format an empty cell as number (just to be sure) and enter the number 1
    > Edit>Copy
    > Select your data, Edit>Paste Special, check multiply
    >
    > --
    >
    > Kind Regards,
    >
    > Niek Otten
    >
    > Microsoft MVP - Excel
    >
    > "Gaurav" <Gaurav @discussions.microsoft.com> wrote in message
    > news:D4BF1495-6501-40F2-8BFF-0DC1384BE865@microsoft.com...
    > >I have some values in a row like (A5:G5)
    > > 0.0035,0.0038,0.0029,0.0038,0.0022,0.0038,0.0038.
    > > In cell A8 I have formula =Min(A5:G5) and it gives me values 0.0038
    > > instead
    > > of 0.0022.
    > > I am using Excel 2003.
    > > I have tried checking the format of the cells copying psting to a new work
    > > boomas values but no help
    > > In have even tried =Min(Transpose(A5:G5)) but no help.
    > >

    >
    >
    >


+ 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