The problem is that the IMSUB function returns text values (and text has a
numerical value of 0). Since you are dealing with imaginary numbers, it is a
bit harder for XL to clearly define what is the "minimum". A possibility
would be to use either the IMABS function to convert the text into a single
value. Then MIN function could then be used to find that. If you then wanted
to know the original complex number, could combine with a MATCH and INDEX...

Let's say that A1:A5 is your IMSUB formulas. B1:B5 contains the IMABS
formulas. To find the minimum value in A1:A5 based on the values in B1:B5,
you could do this:

=INDEX(A1:A5,MATCH(MIN(B1:B5),B1:B5,0))
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Caithness Girl" wrote:

I have a list of values that have been generated by a formula (IMSUB). I want
to be able to show the minimum of these values in a cell but using the MIN
and MINA functions, these just come back with 0. There isn't a 0 in the list
of numbers. Please help - I am a bit of a "noddy" with Excel
unfortunately......