RincewindWIZZ Wrote:

={MIN(IF(E10:E14B8,E10:E14))} where the values are all numeric works
just fine so why does the custom function not work?


Have you tried =IF(MinChar(E10:E14)B8,MinChar(E10:E14)) ?

I noticed that =IF(E10B8,E10) works with letters just fine, but if you
replace E10 with the array E10:E14 it throws an error. So I am thinking
that it works sort of like the MINA function which has the following
caveat.

If an argument is an array or reference, only values in that array or
reference are used. Empty cells and text values in the array or
reference are ignored.


--
sbakker
------------------------------------------------------------------------
sbakker's Profile: http://www.excelforum.com/member.php...o&userid=23645
View this thread: http://www.excelforum.com/showthread...hreadid=373901