Min formula

Autumn · Apr 25th, 2002, 02:47 PM

Does anyone know how I can set up a formula to take the minimum of a column only if it is over 0?

Aladin Akyurek · Apr 25th, 2002, 02:51 PM

Quote:

On 2002-04-25 13:47, Autumn wrote:
Does anyone know how I can set up a formula to take the minimum of a column only if it is over 0?

Array-enter:

=MIN(IF(A1:A100>0,A1:A100))

To array-enter a formula you need to hit control+shift+enter at the same time, not just enter.

Edited to cover the condition of over zero.

Aladin

[ This Message was edited by: Aladin Akyurek on 2002-04-25 13:54 ]

Mark W. · Apr 25th, 2002, 02:52 PM

{=MIN(IF(A1:A10>0,A1:A10))}

Note: This is an array formula which is entered using the Control+Shift+Enter key combination. For more information see the Excel Help Index topic for "About array formulas and how to enter them".

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Apr 25th, 2002, 02:47 PM	#1
Autumn New Member Join Date: Apr 2002 Posts: 8	Does anyone know how I can set up a formula to take the minimum of a column only if it is over 0?

Apr 25th, 2002, 02:52 PM	#3
Mark W. MrExcel MVP Join Date: Feb 2002 Location: Austin, Texas USA Posts: 11,654	{=MIN(IF(A1:A10>0,A1:A10))} Note: This is an array formula which is entered using the Control+Shift+Enter key combination. For more information see the Excel Help Index topic for "About array formulas and how to enter them".