formula for a cell which is blank returns populated cell

[Guest]

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.

 

[Guest]

Hi Gracey1:

Try this:

=IF(AT12>=0,MIN(M12,AT12,if(AP12="",M12,AP12)),???)

note the ??? is the vaue if AT12 < 0

As you say M12 and AT12 are values and should be numbers so therefore if
AP12 is blank replace it with M12 as that is one of the min values.