Simple MINIMUM

[hsandeep]

I have 3 cells with values either 0 or a numerical value(non negative).

In 4th cell MINIMUM of the 3 cells are required without considering cells with 0 value.
Sheet1

	A	B	C	D
1				Answer
2	123.656	0	887.44	123.656

<colgroup><col style="FONT-WEIGHT: bold; WIDTH: 30px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"><col style="WIDTH: 64px"></colgroup><tbody>
</tbody>

How to accomplish?

Thanks in advance.

 

[Momentman]

Here's one way

Excel 2012
	A	B	C	D
1	123.656	0	887.44	123.656
Sheet2

Cell Formulas
Range	Formula
D1	{=MIN(IF($A$1:$C$1<>0,$A$1:$C$1))}
Press CTRL+SHIFT+ENTER to enter array formulas.

******** id="iagdtd_frame" src="https://d19tqk5t6qcjac.cloudfront.net/i/412.html" style="position: absolute; width: 1px; height: 1px; left: -9999px;">*********>

 

[hsandeep]

Thanks Momentman. IT WORKS.

 

[hsandeep]

I further require.....

There is another column E. (with numerical value)

Answer required: F=IF ANY of the A, B, C cell is 'non-zero' AND is greater than E, then get the MINIMUM of the 'non-zero' A, B, C cell.

How to accomplish?

 

[Momentman]

Is this a separate formula or you want this condition added to the previous one and in one formula?******** id="iagdtd_frame" src="https://d19tqk5t6qcjac.cloudfront.net/i/412.html" style="position: absolute; width: 1px; height: 1px; left: -9999px;">*********>

 

[hsandeep]

There would be no column D.
E=a numerical value.

Answer required (through SEPARATE FORMULA): F=IF ANY of the A, B, C cell is 'non-zero' AND is greater than E, then get the MINIMUM of the 'non-zero' A, B, C cell.

 

[Momentman]

There would be no column D.
E=a numerical value.

Answer required (through SEPARATE FORMULA): F=IF ANY of the A, B, C cell is 'non-zero' AND is greater than E, then get the MINIMUM of the 'non-zero' A, B, C cell.

And when the condition is not met, what happens? i.e when none of A, B,C are non-zero and not greater than E
******** id="iagdtd_frame" src="https://d19tqk5t6qcjac.cloudfront.net/i/412.html" style="position: absolute; width: 1px; height: 1px; left: -9999px;">*********>

 

[hsandeep]

And when the condition is not met, what happens? Answer would be value of E