财务、数据统计必会的8个

in hive-150943 •  3 days ago 

财务、数据统计必会的8个 #EXCEL 函数。

VLOOKUP:在指定区域按列查找
XLOOKUP:在指定区域按行查找
IF:条件判断
SUMIF:对指定区域按条件求和(AVERAGEIF同理)
FIND:文字查找
CHOOSE:索引,根据参数返回对应位置的值
INDEX:在指定区域索引
MATCH:在指定区域查找值对应的位置

#Slime @Tip_Tag



Authors get paid when people like you upvote their post.
If you enjoyed what you read here, create your account today and start earning FREE STEEM!