如何用excel中的if函数表达关于天气分类的函数式

当A1为“大雨”时，显示为“在家”；当A1为“小雨”时，显示为“随便”；当A1为“中雨”时，显示为“带伞”；当A1为“晴”时，显示为“高兴”。

---

=IF(A1="大雨","在如孙兄家",IF(A1="小雨","随渣袭便",IF(A1="中雨","带伞",IF(A1="晴凯罩","高兴",""))))

---

试试看吧！
=IF(A1="大雨","在家乱族搏",IF(A1="穗正小雨","哗祥随便",IF(A1="中雨","带伞",IF(A1="晴","高兴",""))))

---