如何结合这两个公式

Question

=IF((OR(E50>150000000,E50<-150000000)),"variance greater than threshold","")

=(IF(ABS(F50)>3%,"% Greater than threshold",""))

我无法组合上述公式..它给了我一个正确和错误的答案，但我需要一个单元格中类似“方差大于，％大于阈值”的内容。

Answer 1

使用 & 将两者连接起来：

=MID(IF((OR(E50>150000000,E50<-150000000)),", variance greater than threshold","") &  (IF(ABS(F50)>3%,", % Greater than threshold","")),3,999)