Show Minimum value

[Arno]

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!!

 

[Gary''s Student]

=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

 

[Arno]

Hi,

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

Ciao Grazie Arno