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.

Try this

Format an empty cell as number (just to be sure) and enter the number 1
EditCopy
Select your data, EditPaste Special, check multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Gaurav" <Gaurav @discussions.microsoft.com wrote in message
...
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.

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
EditCopy
Select your data, EditPaste Special, check multiply

--

Kind Regards,

Niek Otten

Microsoft MVP - Excel

"Gaurav" <Gaurav @discussions.microsoft.com wrote in message
...
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.