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