excel计算公式大全，excel(函数)计算公式使用方法
=C8*$C$5+D8*$D$5+E8*$E$5
=SUMPRODUCT(C8:E8,$C$5:$E$5)
=IF(B5>=90,"优秀",IF(B5>=80,"良","及格"))
=IF(条件,条件为真返回值,条件为假返回值)
=IF(AND(A4>=-5,A4<=5),"合格","不合格") =IF(ABS(A4)<=5,"合格","不合格")
=VLOOKUP(A4,F:G,2,0)
=VLOOKUP(查找值,在哪个区域查找,返回区域第几列,精确或模糊匹配)
=VLOOKUP($A4,$E:$G,2,0) =VLOOKUP($A4,$E:$G,3,0)
=VLOOKUP($A4,$E:$G,COLUMN(B1),0)
=A4&TEXT(B4,"!_yyyy-m-d") =A4&TEXT(B4,"!_e-m-d")
=SUMIF(C:C,">30000", C:C)
=SUMIF(条件区域,条件,求和区域)
=SUMIF(A:A,"102*",C:C)
本文地址：百科问答频道 https://www.neebe.cn/wenda/868366.html，易企推百科一个免费的知识分享平台，本站部分文章来网络分享，本着互联网分享的精神，如有涉及到您的权益，请联系我们删除，谢谢！
相关阅读
