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

in hive-150943 •  5 months ago 

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

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

#Slime @Tip_Tag



hive-150943 EXCEL Slime
5 months ago by

Downvoting a post can decrease pending rewards and make it less visible. Common reasons:

  • Disagreement on rewards
  • Fraud or plagiarism
  • Hate speech or trolling
  • Miscategorized content or spam

Submit
$0.87
    12 votes
    0
    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!