EXCEL表格气温求最低最高和平均数,blueguoguoqyc来帮帮忙答:B6=MAX(LEFT(B3,FIND("℃",B3)-1),LEFT(C3,FIND("℃",C3)-1),LEFT(D3,FIND("℃",D3)-1),LEFT(E3,FIND("℃",E3)-1),LEFT(F3,FIND("℃",F3)-1))&"℃"B7=MIN(MID(B3,FIND("~",B3)+1,LEN(B3)-1-FIND("~",B3)),MID(C3,FIND("~",C3)+1,LEN(C3)-1-FIND("~...