=SI(MIN(B6:B7)=B6;"Min";"Max")
=SI(MIN(B6:B7)=B7;"Min";"Max")
=SI(ESTNUM(B6);SI(MIN(B6:B7)=B6;"Min";"Max");"")
=SI(ESTNUM(B6);SI(NB(B6:B7)=2;SI(MIN(B6:B7)=B6;"Min";"Max");SI(B7="";SI(
MIN(B5:B6)=B6;"Min";"Max")));"")
[COLOR="DarkSlateGray"][B]=INDEX({"";"Min";"Max";"Min & Max"};1+(B7<>"")*((MIN($B$6:$B$7)=B7)+2*(MAX($B$6:$B$7)=B7)))[/B][/COLOR]
=SI(OU(NB(B3:B4)<2;B3=B4);"";SI(B3[COLOR="Red"]<[/COLOR]B4;"Min";"Max"))
=SI(OU(NB(B3:B4)<2;B3=B4);"";SI(B3[COLOR="red"]>[/COLOR]B4;"Min";"Max"))