combining formulas

[Rene]

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D1140))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you

 

[Gary''s Student]

Encompase the two equations like:

=MIN(MIN(),MIN())

 

[Rene]

=MIN(MIN(J11:J40,"b",D1140),MIN('[abc.xlsx]2008 mine'!G313:G367))
{=MIN(MIN(if(J11:J40,"b",D1140),MIN('[abc.xlsx]2008 mine'!G313:G367)))}

both return a value error

Encompase the two equations like:

=MIN(MIN(),MIN())
--
Gary''s Student - gsnu200813

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D1140))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you

 

[Gary''s Student]

Your goal of using only one formula is good. However, cells are cheap.

Putting one min formula in, say Z1, and the other in Z2 and then using :
=MIN(Z1,Z2)

Only costs two extra cells and avoids the headache
--
Gary''s Student - gsnu200813

=MIN(MIN(J11:J40,"b",D1140),MIN('[abc.xlsx]2008 mine'!G313:G367))
{=MIN(MIN(if(J11:J40,"b",D1140),MIN('[abc.xlsx]2008 mine'!G313:G367)))}

both return a value error

Encompase the two equations like:

=MIN(MIN(),MIN())
--
Gary''s Student - gsnu200813

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D1140))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you

 

[Gary''s Student]

The MIN(IF is broken

=MIN(IF(J11:J40="b",D1140,"")) is the correct array part.
--
Gary''s Student - gsnu200813

=MIN(MIN(J11:J40,"b",D1140),MIN('[abc.xlsx]2008 mine'!G313:G367))
{=MIN(MIN(if(J11:J40,"b",D1140),MIN('[abc.xlsx]2008 mine'!G313:G367)))}

both return a value error

Encompase the two equations like:

=MIN(MIN(),MIN())
--
Gary''s Student - gsnu200813

Hello again. I've tried and tried to combine the two formulas to find the MIN
(one number)...help.

{=MIN(IF(J11:J40="b",D1140))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

Thank you