Show Minimum value
 

HI,

In cells A1 to A4 I have formulas picking up values from other cells.
If any of them is 'empty' it shows #N/A and it is preventing cell A5
=MIN(A1:A4) from showing the minimum value.

Is there a way to solve this

Thank you!!

Show Minimum value
 

=MIN(IF(ISNUMBER(A1:A4),A1:A4,""))
this is an array formula that must be entered with CNTRL-SHFT-ENTER rather
than just the ENTER key
--
Gary''s Student - gsnu200812


"Arno" wrote:

HI,

In cells A1 to A4 I have formulas picking up values from other cells.
If any of them is 'empty' it shows #N/A and it is preventing cell A5
=MIN(A1:A4) from showing the minimum value.

Is there a way to solve this

Thank you!!

Show Minimum value
 

Hi,

It has worked straight away.
I really thank you because on my own I would not have made it.

Ciao Grazie Arno :)

"Arno" wrote:

HI,

In cells A1 to A4 I have formulas picking up values from other cells.
If any of them is 'empty' it shows #N/A and it is preventing cell A5
=MIN(A1:A4) from showing the minimum value.

Is there a way to solve this

Thank you!!