Simple If/Min Formula

[Aussibuilder50000]

I have a if(min) formula.

There are four (4) criteria

Cell A1,B1,C1 & D1

The formula looks at the data in each cell & gives the smallest amount

This part is not the issue

The formula is as follows:

=Min(A1,B1,C1,D1)

My question is as follows

The current formula only works if there is data in all four (4) cells

Is there a way to change the formula so that if one of the cells is 'blank',ignore that cell & give a result being the minimum of the remaining three (3) cells only?

Thank you

[tim201110]

=MIN(IF(NOT(ISBLANK(A1:D1)),A1:D1)) as arrayformula

[Aussibuilder50000]

Hello,

Thank you

What if the cells in question are not all in the same row?

[JeteMc]

If the values were in A1, A2, B1 and B2 then the formula could be modified to read:

=MIN(IF(NOT(ISBLANK(A1:B2)),A1:B2))

Let us know if you have any questions.

[Aussibuilder50000]

Hello,
I tried that formula but could not get it to work.

Have attached the actual spreadsheet explaining the cells & calculations

[JohnTopley]

Formula in G8 for F8=7 does not agree with your description

IF($F8=7,MIN($G$2,$C8*$B8*$I$14)

vs

smallest amount of either, G2,D8*I14 or C8*E8.