I am writing a formula to return a minimum value from an array of cells, but
if the cells are blank it does not return any value, how can I rectify this,
shown is my formula.
=IF(AT12=0,MIN(M12,AT12,AP12))
M and AT are populated and when I take out AP it returns the lower value,
but when I enter AP which is a formula returning no answer, my other formula
returns a blank cell.