Excel如何插入图片,五种简单方法帮你快速实现
90665 2024-09-19
=SUM(A1:A10)
=AVERAGE(B1:B10)
=MAX(C1:C10)
和 =MIN(C1:C10)
=IF(D2>100, "优秀", "合格")
=COUNT(E1:E10)
和 =COUNTA(E1:E10)
=VLOOKUP(F2, G1:H10, 2, FALSE)
=HLOOKUP(I2, J1:M3, 2, FALSE)
=CONCATENATE("姓名:", A2, ",分数:", B2)
=INDEX(G1:G10, MATCH(H2, H1:H10, 0))
=LEFT(A2, 3)
=LEN(B2)
=TRIM(C2)
=ROUND(D2, 2)
=RANK(E2, E1:E10)
=DATE(2024, 10, 13)
=YEAR(F2)
=NOW()
和 =TODAY()
=SUMIF(G1:G10, ">100")
=TEXT(H2, "yyyy-mm-dd")
=SUBSTITUTE(I2, "旧字符", "新字符")
Excel函数公式宝典,20个公式从入门到精通