MAX(IF and MIN(IF not giving results expected

alec1986

New Member
Hi all,

I have created a MAX(IF command in order to find the maximum temperature, from a table, between two times. it looks like this:

<h5,c16:c28226,0)))}, and="" it="" works="" great!
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))
=MAX(IF(J16:J28226>G5,IF(J16:J28226"lessThan"H5,C16:C28226,0)))<h5,c16:c28226,0)))

Temperatures are tabled in C16:C28226
Times the temperatures were taken in J16:JJ28226
Reference Temperatures in G5 and H5.

I would also like to create exactly the same formula, using MIN, to look like this:
<h5,c16:c28226,0)))}
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))

=MAX(IF(J16:J28226>G5,IF(J16:J28226<h5,c16:c28226,0)))
"lessThan"H5,C16:C28226,0)))

But every time I do, it produces 0, insisting that is it 'FALSE'. Both formulas have {}, i just haven't added them here.

Can anyone see any logical reason why this might be?
Other times i get a 'false' reading are when the times (based in hours) are the same, next to each other (say, 9 as a minimum and 10 as a maximum) or inverse (say 10 as a minimum and 9 as a maximum).

Any help would be hugely appreciated, i feel like its something minor. Also, my apologies, the formulas will not paste correctly (even in plain text!) the both end with "Less than"H5,C16:C28226,0))). apologies for the poor formatting.
<h5,c16:c28226,0)))". sorry.

Thankyou!</h5,c16:c28226,0)))".></h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))}
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))},>

Last edited:

alec1986

New Member
Hi all,

I have created a MAX(IF command in order to find the maximum temperature, from a table, between two times. it looks like this:

Code:
``````<h5,c16:c28226,0)))}, and="" it="" works="" great!
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))
=MAX(IF(J16:J28226>G5,IF(J16:J28226<H5,C16:C28226,0)))``````
<h5,c16:c28226,0)))

Temperatures are tabled in C16:C28226
Times the temperatures were taken in J16:JJ28226
Reference Temperatures in G5 and H5.

I would also like to create exactly the same formula, using MIN, to look like this:
<h5,c16:c28226,0)))}
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))
<h5,c16:c28226,0)))

Code:
``````=MIN(IF(J16:J28226>G5,IF(J16:J28226<h5,c16:c28226,0)))
<H5,C16:C28226,0)))``````
But every time I do, it produces 0, insisting that is it 'FALSE'. Both formulas have {}, i just haven't added them here.

Can anyone see any logical reason why this might be?
Other times i get a 'false' reading are when the times (based in hours) are the same, next to each other (say, 9 as a minimum and 10 as a maximum) or inverse (say 10 as a minimum and 9 as a maximum).

Any help would be hugely appreciated, i feel like its something minor. Also, my apologies, the formulas will not paste correctly (even in plain text!) the both end with "Less than"H5,C16:C28226,0))). apologies for the poor formatting.
<h5,c16:c28226,0)))". sorry.

Thankyou!</h5,c16:c28226,0)))".></h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))}
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))
</h5,c16:c28226,0)))},>

RasGhul

Well-known Member
Maybe this?

<b>Note: Do not try and enter the {} manually yourself</b></td></tr></table><br />

alec1986

New Member
Worked perfectly, thank you! can I infer from this that instead of using IF after IF after IF, i can use *? does it do the same thing?

RasGhul

Well-known Member
you're welcome

AND boolean logic uses * between 2 arrays for True & True in (\$J\$2:\$J\$28226>G5)*(\$J\$2:\$J\$28226<h5< font="">)
</h5<>
<h5< font="">
IF(then IF(cut the array in half.

</h5<>