Question

EXCEL的题目。关于IF函数的。求解答。

使用IF函数，对Sheet1“温度情况表”中的“温度较高的城市”列进行填充，填
充结果为城市名称。

Answer 1

D3
=if(B3>C3,"杭州",if(B3<C3,"上海","杭州上海"))
相等时两个城市都写。向下复制公式到D17
C19
=max(B3:B17)
C20
=min(B3:B17)
C21
=max(C3:C17)
C22
=min(C3:C17)

Answer 2

D3
=if(B3>C3,"杭州",if(B3<C3,"上海","杭州上海"))
相等时两个城市都写。向下复制公式到D17
C19
=max(B3:B17)
C20
=min(B3:B17)
C21
=max(C3:C17)
C22
=min(C3:C17)

Answer 3

在D3单元格输入公式=if(B2>C2,"杭州",if(B2<C2,"上海","一样高"))，然后向下复制