Excel如何插入图片,五种简单方法帮你快速实现
91515 2024-09-19
=SUM(A1:A100)
=AVERAGE(B1:B50)
=IF(C2>50, "通过", "不通过")
=VLOOKUP(D2, E1:F100, 2, FALSE)
=HLOOKUP(G2, H1:I10, 2, FALSE)
=MATCH("目标", J1:J100, 0)
=INDEX(K1:K100, MATCH("产品A", L1:L100, 0))
=COUNTIF(M1:M50, ">100")
=SUMIF(N1:N50, "A", O1:O50)
=LEFT(P1, 5)
=CONCATENATE("客户:", Q1, " 地区:", R1)
=TEXT(S2, "yyyy-mm-dd")
=TRIM(T2)
=MAX(U1:U50)
和 =MIN(U1:U50)
=ROUND(V2, 2)
=RAND()
=NOW()
=YEAR(W2)
=DAYS(X2, X1)
=SUBTOTAL(1, Y1:Y100)
Excel函数公式大全及用法,20个公式助你轻松解决数据问题