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)

本文地址：IT问答频道 https://www.eeeoo.cn/itwenda/868366.html，嗨游网一个专业手游免费下载攻略知识分享平台，本站部分内容来自网络分享，不对内容负责，如有涉及到您的权益，请联系我们删除，谢谢！