excel函数的用法
2023-11-13 本文已影响0人
sunpy
求和 SUM
![](https://img.haomeiwen.com/i5460809/49d0a009e7bef712.png)
![](https://img.haomeiwen.com/i5460809/0b9c988319401a75.png)
想让一列都应用公式,那么选中一个单元格,然后右下角为十字光标,按住向下选中。
比例求和 SUM
![](https://img.haomeiwen.com/i5460809/944303272a255472.png)
条件语句 IF
![](https://img.haomeiwen.com/i5460809/1427f7d970d8c050.png)
最大值
![](https://img.haomeiwen.com/i5460809/c99b7b0dc0241c3a.png)
最小值
![](https://img.haomeiwen.com/i5460809/36ca009f8e56eee9.png)
个数
![](https://img.haomeiwen.com/i5460809/d006b2ddad857479.png)
平均值
![](https://img.haomeiwen.com/i5460809/4fdbacde534780c3.png)
获取前两位字符
![](https://img.haomeiwen.com/i5460809/40060f403e26102d.png)
VLOOKUP函数实现查找
![](https://img.haomeiwen.com/i5460809/74a8ef7e4ae25ea6.png)
VLOOKUP说明:
=VLOOKUP(查找值,查找区域,列序数,[匹配方式])
想让一列都应用公式,那么选中一个单元格,然后右下角为十字光标,按住向下选中。
VLOOKUP说明:
=VLOOKUP(查找值,查找区域,列序数,[匹配方式])