MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Min function to ignor zero


Posted by Jesse on February 14, 2002 1:27 PM

Hi I am trying to write a function using MIN and IF to deliver the lowest number in an array other than zero without returning an error. Can anyone help?

Thanks


Posted by Mark W. on February 14, 2002 1:30 PM

Use {=MIN(IF(A1:A5,A1:A5))}

Note: This is an array formula which must be
entered using the Control+Shift+Enter key
combination. The outermost braces, {}, are not
entered by you -- they're supplied by Excel in
recognition of a properly entered array formula.