Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining formulas
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining formulas
Encompase the two equations like:
=MIN(MIN(),MIN()) -- Gary''s Student - gsnu200813 "Rene" wrote: 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining formulas
=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" wrote: Encompase the two equations like: =MIN(MIN(),MIN()) -- Gary''s Student - gsnu200813 "Rene" wrote: 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining formulas
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" wrote: =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" wrote: Encompase the two equations like: =MIN(MIN(),MIN()) -- Gary''s Student - gsnu200813 "Rene" wrote: 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
combining formulas
The MIN(IF is broken
=MIN(IF(J11:J40="b",D11:D40,"")) is the correct array part. -- Gary''s Student - gsnu200813 "Rene" wrote: =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" wrote: Encompase the two equations like: =MIN(MIN(),MIN()) -- Gary''s Student - gsnu200813 "Rene" wrote: 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Combining 2 Formulas | Excel Discussion (Misc queries) | |||
Combining formulas | Excel Discussion (Misc queries) | |||
Combining two formulas | Excel Worksheet Functions | |||
Combining formulas | Excel Discussion (Misc queries) | |||
Combining two formulas | Excel Worksheet Functions |