combining formulas

  • Thread starter Thread starter Rene
  • Start date Start date
R

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",D11:D40))}
=MIN('[abc.xlsx]2008 Mine'!G313:G367)

Also, same formula using AVERAGE in place of MIN

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

both return a value error

Gary''s Student said:
Encompase the two equations like:

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


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

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

Also, same formula using AVERAGE in place of MIN

Thank you
Click to expand...
Click to expand...
 
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


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

both return a value error

Gary''s Student said:
Encompase the two equations like:

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


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

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

Also, same formula using AVERAGE in place of MIN

Thank you
Click to expand...
Click to expand...
Click to expand...
 
The MIN(IF is broken

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


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

both return a value error

Gary''s Student said:
Encompase the two equations like:

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


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

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

Also, same formula using AVERAGE in place of MIN

Thank you
Click to expand...
Click to expand...
Click to expand...
 
Back
Top