{"code":200,"msg":{"v":2},"time":1779723893,"data":[{"key":"ABS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70558?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":48,"top_cate":"xls","bg_title":"超简单ABS函数 计算绝对值"},"channel":1,"app":"","version":1},{"key":"ACCRINT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70702?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":84,"top_cate":"xls","bg_title":"巧用ACCRINT函数 算定期证券利息"},"channel":1,"app":"","version":1},{"key":"ACCRINTM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70704?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"ACCRINTM函数 到期一次性证券利息"},"channel":1,"app":"","version":1},{"key":"ACOS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69881?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":46,"top_cate":"xls","bg_title":"ACOS函数 计算反余弦值"},"channel":1,"app":"","version":1},{"key":"ACOSH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68921?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":51,"top_cate":"xls","bg_title":"ACOSH函数 计算反双曲余弦值"},"channel":1,"app":"","version":1},{"key":"ADDRESS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70492?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":116,"top_cate":"xls","bg_title":"ADDRESS函数 转化绝对引用"},"channel":1,"app":"","version":1},{"key":"AGGREGATE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15318?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":98,"top_cate":"xls","bg_title":"AGGREGATE函数"},"channel":1,"app":"","version":2},{"key":"AMORDEGRC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70703?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":84,"top_cate":"xls","bg_title":"AMORDEGRC函数 计算财务常用的折旧值"},"channel":1,"app":"","version":1},{"key":"AMORLINC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68790?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":79,"top_cate":"xls","bg_title":"AMORLINC函数"},"channel":1,"app":"","version":1},{"key":"AND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70690?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"一分钟 掌握AND函数"},"channel":1,"app":"","version":1},{"key":"AREAS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69664?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":134,"top_cate":"xls","bg_title":"巧用AREAS函数 计算区域个数"},"channel":1,"app":"","version":1},{"key":"ASC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70001?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"巧用ASC函数将 全角字符转换成半角字符"},"channel":1,"app":"","version":1},{"key":"ASIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70094?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"巧用ASIN函数 计算反正弦值"},"channel":1,"app":"","version":1},{"key":"ASINH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68869?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":86,"top_cate":"xls","bg_title":"巧用ASINH函数 计算反双曲正弦值"},"channel":1,"app":"","version":1},{"key":"ATAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69360?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"巧用ATAN函数 求反正切值"},"channel":1,"app":"","version":1},{"key":"ATAN2","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69479?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":56,"top_cate":"xls","bg_title":"ATAN2函数 计算给定坐标反正切值"},"channel":1,"app":"","version":1},{"key":"ATANH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67691?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":77,"top_cate":"xls","bg_title":"ATANH函数 计算数值反双曲正切值"},"channel":1,"app":"","version":1},{"key":"AVEDEV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69877?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"AVEDEV函数 计算平均绝对偏差"},"channel":1,"app":"","version":1},{"key":"AVERAGE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69697?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"AVERAGE函数 快速求数据平均值"},"channel":1,"app":"","version":1},{"key":"AVERAGEA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69433?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":48,"top_cate":"xls","bg_title":"AVERAGEA函数 计算有文本的数字平均值"},"channel":1,"app":"","version":1},{"key":"AVERAGEIF","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69677?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":70,"top_cate":"xls","bg_title":"AVERAGEIF函数 指定条件求平均值"},"channel":1,"app":"","version":1},{"key":"AVERAGEIFS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69355?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":79,"top_cate":"xls","bg_title":"AVERAGEIFS 计算多条件的平均值"},"channel":1,"app":"","version":1},{"key":"BAHTTEXT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69491?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"BAHTTEXT函数将 数字转换成泰铢"},"channel":1,"app":"","version":1},{"key":"BESSELI","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70728?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":84,"top_cate":"xls","bg_title":"BESSELI函数 返回修正贝塞尔函数"},"channel":1,"app":"","version":1},{"key":"BESSELJ","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67676?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"BESSELJ函数 返回贝塞尔函数值"},"channel":1,"app":"","version":1},{"key":"BESSELK","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67671?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"BESSELK函数计算 贝塞尔Kn(x)的函数"},"channel":1,"app":"","version":1},{"key":"BESSELY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67752?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":64,"top_cate":"xls","bg_title":"BESSELY函数 快速计算贝塞尔函数值"},"channel":1,"app":"","version":1},{"key":"BETADIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69058?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":97,"top_cate":"xls","bg_title":"BETADIST函数 累积分布函数"},"channel":1,"app":"","version":1},{"key":"BETAINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69059?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":97,"top_cate":"xls","bg_title":"BETAINV函数求 分布函数反函数值"},"channel":1,"app":"","version":1},{"key":"BIN2DEC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67683?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":56,"top_cate":"xls","bg_title":"BIN2DEC函数 二进制数转十进制数"},"channel":1,"app":"","version":1},{"key":"BIN2HEX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69357?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":70,"top_cate":"xls","bg_title":"BIN2HEX函数 二进制转换成十六进制"},"channel":1,"app":"","version":1},{"key":"BIN2OCT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67564?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"BIN2OCT函数 二进制转八进制数"},"channel":1,"app":"","version":1},{"key":"BINOM.DIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69684?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":92,"top_cate":"xls","bg_title":"BINOM.DIST函数"},"channel":1,"app":"","version":1},{"key":"BINOM.DIST.RANGE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/411.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":86,"show_type":"icon","top_cate":"xls","bg_title":"BINOM.DIST.RANGE函数"},"channel":1,"app":"","version":1},{"key":"BINOM.INV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68925?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"BINOM.INV函数"},"channel":1,"app":"","version":1},{"key":"BINOMDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69682?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":97,"top_cate":"xls","bg_title":"BINOMDIST函数"},"channel":1,"app":"","version":1},{"key":"BITAND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70147?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"巧用BITAND函数 求C语言中的按位与"},"channel":1,"app":"","version":1},{"key":"BITLSHIFT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70495?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":70,"top_cate":"xls","bg_title":"BITLSHIFT函数 二进制添零并转换十进制"},"channel":1,"app":"","version":1},{"key":"BITOR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69199?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":56,"top_cate":"xls","bg_title":"BITOR函数计算 两个数值按位运算"},"channel":1,"app":"","version":1},{"key":"BITRSHIFT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67244?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"BITRSHIFT函数 计算数值右移的数值"},"channel":1,"app":"","version":1},{"key":"BITXOR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67243?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"BITXOR函数 返回数值异或值"},"channel":1,"app":"","version":1},{"key":"CEILING","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70206?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":82,"top_cate":"xls","bg_title":"巧用CEILING函数 向上舍入"},"channel":1,"app":"","version":1},{"key":"CELL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70028?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"超级神秘的 CELL函数"},"channel":1,"app":"","version":1},{"key":"CHAR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70490?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"巧用CHAR函数 将代码转换为字符"},"channel":1,"app":"","version":1},{"key":"CHIDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70733?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"巧用CHIDIST函数 检验初始假设"},"channel":1,"app":"","version":1},{"key":"CHIINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68936?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"CHIINV函数"},"channel":1,"app":"","version":1},{"key":"CHISQ.DIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67729?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":74,"top_cate":"xls","bg_title":"CHISQ.DIST函数"},"channel":1,"app":"","version":1},{"key":"CHISQ.INV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68875?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"CHISQ.INV函数"},"channel":1,"app":"","version":1},{"key":"CHITEST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70732?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":75,"top_cate":"xls","bg_title":"求检验假设的 CHITEST函数值"},"channel":1,"app":"","version":1},{"key":"CHOOSE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70491?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"巧用CHOOSE函数 筛选数据"},"channel":1,"app":"","version":1},{"key":"CHOOSECOLS","value":{"url":"https:\/\/home.wps.cn\/topic\/14671?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":40,"top_cate":"xls","bg_title":"CHOOSECOLS返回数组或引用中的列"},"channel":1,"app":"et","version":1},{"key":"CHOOSEROWS","value":{"url":"https:\/\/home.wps.cn\/topic\/14672?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"CHOOSEROWS返回数组或引用中的行"},"channel":1,"app":"et","version":1},{"key":"CLEAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67505?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"CLEAN函数删除 文本中不能打印的字符"},"channel":1,"app":"","version":1},{"key":"CODE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68923?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"CODE函数 查询字符编号"},"channel":1,"app":"","version":1},{"key":"COLUMN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70683?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"COLUMN函数 标注单元格列号"},"channel":1,"app":"","version":1},{"key":"COLUMNS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70106?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":42,"top_cate":"xls","bg_title":"COLUMNS函数 统计列数项目"},"channel":1,"app":"","version":1},{"key":"COMBIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69056?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"巧用COMBIN函数 求组合数"},"channel":1,"app":"","version":1},{"key":"COMPLEX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69502?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"巧用COMPLEX函数 批量创建复数"},"channel":1,"app":"","version":1},{"key":"CONCAT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67690?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"巧用CONCAT函数 组合文本"},"channel":1,"app":"","version":1},{"key":"CONCATENATE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70598?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"CONCATENATE函数"},"channel":1,"app":"","version":1},{"key":"CONFIDENCE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69371?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"CONFIDENCE 计算置信区间"},"channel":1,"app":"","version":1},{"key":"CONVERT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69374?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"CONVERT函数 全能的单位转换器"},"channel":1,"app":"","version":1},{"key":"CORREL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69882?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":44,"top_cate":"xls","bg_title":"CORREL函数 计算数据集相关系数"},"channel":1,"app":"","version":1},{"key":"COS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69681?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"巧用COS函数 求余弦值"},"channel":1,"app":"","version":1},{"key":"COSH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67685?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":52,"top_cate":"xls","bg_title":"COSH函数 计算双曲余弦值"},"channel":1,"app":"","version":1},{"key":"COUNT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70588?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"COUNT函数 一键统计有参数的项目"},"channel":1,"app":"","version":1},{"key":"COUNTA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69871?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":51,"top_cate":"xls","bg_title":"巧用COUNTA函数 计算非空单元格个数"},"channel":1,"app":"","version":1},{"key":"COUNTBLANK","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70101?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":57,"top_cate":"xls","bg_title":"COUNTBLANK函数"},"channel":1,"app":"","version":1},{"key":"COUNTIF","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70699?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":117,"top_cate":"xls","bg_title":"用COUNTIF 统计字符出现次数"},"channel":1,"app":"","version":1},{"key":"COUNTIFS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/133.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":80,"show_type":"icon","top_cate":"xls","bg_title":"COUNTIFS函数统计 满足不同条件数据"},"channel":1,"app":"","version":1},{"key":"COUPDAYBS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67506?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":82,"top_cate":"xls","bg_title":"COUPDAYBS函数 计算付息期到结算日天数"},"channel":1,"app":"","version":1},{"key":"COUPDAYS","value":{"url":"https:\/\/www.wps.cn\/learning\/article\/detail\/id\/181058","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"wps","bg_title":"表格神操作，简单却实用到爆"},"channel":1,"app":"","version":2},{"key":"COUPDAYSNC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68791?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":88,"top_cate":"xls","bg_title":"COUPDAYSNC函数"},"channel":1,"app":"","version":1},{"key":"COUPNCD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13467?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":128,"top_cate":"xls","bg_title":"COUPNCD函数"},"channel":1,"app":"","version":2},{"key":"COUPNUM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13461?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":96,"top_cate":"xls","bg_title":"COUPNUM函数"},"channel":1,"app":"","version":2},{"key":"COUPPCD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13446?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":126,"top_cate":"xls","bg_title":"COUPPCD函数"},"channel":1,"app":"","version":2},{"key":"COVAR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69016?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"COVAR函数 计算协方差"},"channel":1,"app":"","version":1},{"key":"COVARIANCE.P","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13454?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":44,"top_cate":"xls","bg_title":"Covariance.P函数"},"channel":1,"app":"","version":2},{"key":"COVARIANCE.S","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13452?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"Covariance.S函数"},"channel":1,"app":"","version":2},{"key":"CRITBINOM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67513?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"CRITBINOM函数"},"channel":1,"app":"","version":1},{"key":"CUMIPMT","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/500.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":72,"show_type":"icon","top_cate":"xls","bg_title":"CUMIPMT函数 两个付款期之间累计利息"},"channel":1,"app":"","version":1},{"key":"CUMPRINC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70718?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":143,"top_cate":"xls","bg_title":"CUMPRINC 快速计算应还贷款本金"},"channel":1,"app":"","version":1},{"key":"DATE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70600?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"巧用DATE函数 转换日期格式"},"channel":1,"app":"","version":1},{"key":"DATEDIF","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70602?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":89,"top_cate":"xls","bg_title":"DATEDIF函数 计算日期间隔数"},"channel":1,"app":"","version":1},{"key":"DATEVALUE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70040?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":82,"top_cate":"xls","bg_title":"DATEVALUE 日期转换成序列号"},"channel":1,"app":"","version":1},{"key":"DAVERAGE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70204?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"巧用DAVERAGE函数 求平均值"},"channel":1,"app":"","version":1},{"key":"DAY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69665?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":52,"top_cate":"xls","bg_title":"巧用DAY函数 显示日期天数"},"channel":1,"app":"","version":1},{"key":"DAYS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15337?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":97,"top_cate":"xls","bg_title":"DAYS函数"},"channel":1,"app":"","version":1},{"key":"DAYS360","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70152?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":80,"top_cate":"xls","bg_title":"DAYS360函数 计算相差天数"},"channel":1,"app":"","version":1},{"key":"DB","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/334.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":95,"show_type":"icon","top_cate":"xls","bg_title":"DB函数计算 给定期间内折旧值"},"channel":1,"app":"","version":1},{"key":"DCOUNT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70512?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"DCOUNT函数统计 符合条件的数据个数"},"channel":1,"app":"","version":1},{"key":"DCOUNTA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69876?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":70,"top_cate":"xls","bg_title":"Dcounta函数统计 满足指定条件的个数"},"channel":1,"app":"","version":1},{"key":"DDB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69493?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"DDB函数双倍余额 递减计算折旧额"},"channel":1,"app":"","version":1},{"key":"DEC2BIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68872?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"DEC2BIN函数 将十进制转换二进制数"},"channel":1,"app":"","version":1},{"key":"DEC2HEX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70574?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":77,"top_cate":"xls","bg_title":"十进制数如何 转换成十六进制数"},"channel":1,"app":"","version":1},{"key":"DEC2OCT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70727?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":122,"top_cate":"xls","bg_title":"如何将十进制数 转换成八进制数"},"channel":1,"app":"","version":1},{"key":"DEGREES","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69372?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"DEGREES函数 弧度值转换角度值"},"channel":1,"app":"","version":1},{"key":"DELTA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67726?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":70,"top_cate":"xls","bg_title":"巧用DELTA函数 判断两数值是否相等"},"channel":1,"app":"","version":1},{"key":"DEVSQ","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69489?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"DEVSQ函数 计算偏差平方和"},"channel":1,"app":"","version":1},{"key":"DGET","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70102?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":105,"top_cate":"xls","bg_title":"DGET函数快速 按条件查找个值"},"channel":1,"app":"","version":1},{"key":"DISC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13459?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":91,"top_cate":"xls","bg_title":"DISC函数"},"channel":1,"app":"","version":2},{"key":"DMAX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69874?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":48,"top_cate":"xls","bg_title":"DMAX函数筛选 满足条件的最大数值"},"channel":1,"app":"","version":1},{"key":"DMIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69477?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"DMIN函数筛选 满足条件的最小数值"},"channel":1,"app":"","version":1},{"key":"DOLLAR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69062?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":81,"top_cate":"xls","bg_title":"DOLLAR函数 将数值转换货币格式"},"channel":1,"app":"","version":1},{"key":"DOLLARDE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13458?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"DOLLARDE函数"},"channel":1,"app":"","version":2},{"key":"DOLLARFR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13457?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":47,"top_cate":"xls","bg_title":"DOLLARFR函数"},"channel":1,"app":"","version":2},{"key":"DPRODUCT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70568?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":92,"top_cate":"xls","bg_title":"DPRODUCT函数 计算利润乘积"},"channel":1,"app":"","version":1},{"key":"DROP","value":{"url":"https:\/\/home.wps.cn\/topic\/14673?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"DROP从数组开头或结尾删除行或列数据"},"channel":1,"app":"et","version":1},{"key":"DSTDEV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68868?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":93,"top_cate":"xls","bg_title":"DSTDEV函数计算 条件样本估算标准偏差"},"channel":1,"app":"","version":1},{"key":"DSTDEVP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68788?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"DSTDEVP函数 计算满足条件标准偏差"},"channel":1,"app":"","version":1},{"key":"DSUM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70025?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"巧用DSUM函数 快速条件求和"},"channel":1,"app":"","version":1},{"key":"DURATION","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13448?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":115,"top_cate":"xls","bg_title":"DURATION函数"},"channel":1,"app":"","version":2},{"key":"DVAR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67753?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":88,"top_cate":"xls","bg_title":"DVAR函数计算 数据库样本总体方差"},"channel":1,"app":"","version":1},{"key":"DVARP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67675?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":86,"top_cate":"xls","bg_title":"DVARP函数计算满足 条件样本的总体方差"},"channel":1,"app":"","version":1},{"key":"EDATE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70497?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"巧用EDATE函数 批量计算到期日"},"channel":1,"app":"","version":1},{"key":"ENCODEURL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15328?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"ENCODEURL函数"},"channel":1,"app":"","version":1},{"key":"EOMONTH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70197?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"EOMONTH函数 计算到期日"},"channel":1,"app":"","version":1},{"key":"ERF","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68871?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"巧用ERF函数 计算误差函数值"},"channel":1,"app":"","version":1},{"key":"ERFC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69054?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":51,"top_cate":"xls","bg_title":"ERFC函数 计算数值余误差"},"channel":1,"app":"","version":1},{"key":"ERROR.TYPE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68792?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":71,"top_cate":"xls","bg_title":"ERROR.TYPE函数"},"channel":1,"app":"","version":1},{"key":"EVALUATE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70575?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"强大的计算器 EVALUATE函数"},"channel":1,"app":"","version":1},{"key":"EVEN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69359?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":80,"top_cate":"xls","bg_title":"EVEN函数将数值 向上舍入最接近偶数"},"channel":1,"app":"","version":1},{"key":"EXACT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70606?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"巧用EXACT函数 两项字符串是否一致"},"channel":1,"app":"","version":1},{"key":"EXP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67509?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"EXP函数计算e的n次幂"},"channel":1,"app":"","version":1},{"key":"EXPAND","value":{"url":"https:\/\/home.wps.cn\/topic\/14674?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":99,"top_cate":"xls","bg_title":"EXPAND将数组扩展到指定的维度"},"channel":1,"app":"et","version":1},{"key":"EXPONDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67267?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"EXPONDIST函数 计算指数函数"},"channel":1,"app":"","version":1},{"key":"FACT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68901?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":78,"top_cate":"xls","bg_title":"巧用FACT函数 快速计算数字的阶乘"},"channel":1,"app":"","version":1},{"key":"FACTDOUBLE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/469.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":83,"show_type":"icon","top_cate":"xls","bg_title":"FACTDOUBLE函数"},"channel":1,"app":"","version":1},{"key":"FALSE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70571?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"逻辑函数FALSE的 实例运用"},"channel":1,"app":"","version":1},{"key":"FDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70731?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":84,"top_cate":"xls","bg_title":"快速求出 FDIST函数值"},"channel":1,"app":"","version":1},{"key":"FIELDVALUE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13065?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":88,"top_cate":"xls","bg_title":"利用FIELDVALUE 函数查询股票或基金信息"},"channel":1,"app":"","version":2},{"key":"FILTER","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13046?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":249,"top_cate":"xls","bg_title":"如何使用FILTER函数"},"channel":1,"app":"et","version":2},{"key":"FIND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70622?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":81,"top_cate":"xls","bg_title":"FIND函数定位某值 首次出现的字符数"},"channel":1,"app":"","version":1},{"key":"FINDB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69694?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":81,"top_cate":"xls","bg_title":"FINDB函数定位 某值首次出现的字节数"},"channel":1,"app":"","version":1},{"key":"FINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70730?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":84,"top_cate":"xls","bg_title":"不到0.1秒 算出FINV函数值"},"channel":1,"app":"","version":1},{"key":"FISHER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/305.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"FISHER函数转换数值FISHER变换值"},"channel":1,"app":"","version":1},{"key":"FISHERINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67692?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"FISHERINV函数"},"channel":1,"app":"","version":1},{"key":"FIXED","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69428?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":76,"top_cate":"xls","bg_title":"巧用FIXED函数 指定小数位数取整"},"channel":1,"app":"","version":1},{"key":"FLOOR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69365?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":84,"top_cate":"xls","bg_title":"巧用FLOOR函数 向下舍入"},"channel":1,"app":"","version":1},{"key":"FORECAST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70609?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"Forecast函数 预测数据走向"},"channel":1,"app":"","version":1},{"key":"FORMULATEXT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69883?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":41,"top_cate":"xls","bg_title":"FORMULATEXT函数"},"channel":1,"app":"","version":1},{"key":"FREQUENCY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70000?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"FREQUENCY函数 进行分段统计"},"channel":1,"app":"","version":1},{"key":"FTEST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69013?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"FTEST函数 计算数值双尾概率"},"channel":1,"app":"","version":1},{"key":"FV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70033?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"FV函数计算投资未来值"},"channel":1,"app":"","version":1},{"key":"GAMMADIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67266?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"GAMMADIST函数 返回伽玛分布值"},"channel":1,"app":"","version":1},{"key":"GAMMAINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67264?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"GAMMAINV函数"},"channel":1,"app":"","version":1},{"key":"GAMMALN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67673?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"GAMMALN.PRECISE函数"},"channel":1,"app":"","version":1},{"key":"GAMMALN.PRECISE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67673?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"GAMMALN.PRECISE函数"},"channel":1,"app":"","version":1},{"key":"GCD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67731?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":48,"top_cate":"xls","bg_title":"GCD函数 计算整数的最大公约数"},"channel":1,"app":"","version":1},{"key":"GEOMEAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69429?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"GEOMEAN函数 求几何平均值"},"channel":1,"app":"","version":1},{"key":"GESTEP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70726?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":93,"top_cate":"xls","bg_title":"巧用GESTEP函数 快速查看是否及格"},"channel":1,"app":"","version":1},{"key":"GETPIVOTDATA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70146?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":75,"top_cate":"xls","bg_title":"GETPIVOTDATA函数"},"channel":1,"app":"","version":1},{"key":"GROWTH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69034?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":75,"top_cate":"xls","bg_title":"GROWTH函数 预测未来等比数值"},"channel":1,"app":"","version":1},{"key":"HARMEAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69009?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"HARMEAN函数 求调和平均值"},"channel":1,"app":"","version":1},{"key":"HEX2BIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69878?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"HEX2BIN函数 十六进制转换成二进制"},"channel":1,"app":"","version":1},{"key":"HEX2DEC","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/210.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"HEX2DEC函数 十六进制转换十进制"},"channel":1,"app":"","version":1},{"key":"HEX2OCT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67571?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"HEX2OCT函数 十六进制转八进制"},"channel":1,"app":"","version":1},{"key":"HLOOKUP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68803?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":116,"top_cate":"xls","bg_title":"巧用HLOOKUP 横向查找数据"},"channel":1,"app":"","version":1},{"key":"HOUR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70150?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"巧用HOUR函数 计算小时时差"},"channel":1,"app":"","version":1},{"key":"HSTACK","value":{"url":"https:\/\/home.wps.cn\/topic\/14675?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":37,"top_cate":"xls","bg_title":"HSTACK水平方向拼接数据"},"channel":1,"app":"et","version":1},{"key":"HYPERLINK","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70604?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":83,"top_cate":"xls","bg_title":"HYPERLINK函数"},"channel":1,"app":"","version":1},{"key":"HYPGEOMDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67262?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":57,"top_cate":"xls","bg_title":"HYPGEOMDIST函数"},"channel":1,"app":"","version":1},{"key":"IF","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70701?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"巧用IF函数 判断数据"},"channel":1,"app":"","version":1},{"key":"IFERROR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70624?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":93,"top_cate":"xls","bg_title":"IFERROR函数 自定义报错结果"},"channel":1,"app":"","version":1},{"key":"IFNA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70592?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":71,"top_cate":"xls","bg_title":"IFNA函数 改变错误值#N\/A"},"channel":1,"app":"","version":1},{"key":"IFS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70689?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":89,"top_cate":"xls","bg_title":"如何用IFS函数 实现多条件判断"},"channel":1,"app":"","version":1},{"key":"IMABS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70725?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"巧用IMABS函数 1秒求复数绝对值"},"channel":1,"app":"","version":1},{"key":"IMAGINARY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69676?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"IMAGINARY函数 提取复数的虚系数"},"channel":1,"app":"","version":1},{"key":"IMARGUMENT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69425?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"IMARGUMENT 快速计算复数对应角度"},"channel":1,"app":"","version":1},{"key":"IMCONJUGATE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67511?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":74,"top_cate":"xls","bg_title":"IMCONJUGATE函数计算共轭复数"},"channel":1,"app":"","version":1},{"key":"IMCOS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67507?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"IMCOS函数 快速计算复数余弦值"},"channel":1,"app":"","version":1},{"key":"IMDIV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68903?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":76,"top_cate":"xls","bg_title":"巧用IMDIV函数 快速计算复数的商"},"channel":1,"app":"","version":1},{"key":"IMEXP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70724?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":77,"top_cate":"xls","bg_title":"巧用IMEXP函数 1秒求复数的指数"},"channel":1,"app":"","version":1},{"key":"IMLN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67567?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":42,"top_cate":"xls","bg_title":"IMLN函数 计算自然对数"},"channel":1,"app":"","version":1},{"key":"IMLOG10","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67677?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"巧用IMLOG10函数 计算复数的常用对数"},"channel":1,"app":"","version":1},{"key":"IMLOG2","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68789?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"IMLOG2函数 以2位底数复数对数"},"channel":1,"app":"","version":1},{"key":"IMPOWER","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70723?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":98,"top_cate":"xls","bg_title":"IMPOWER函数 1秒求复数的整数幂"},"channel":1,"app":"","version":1},{"key":"IMPRODUCT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67240?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"IMPRODUCT函数 计算复数乘积"},"channel":1,"app":"","version":1},{"key":"IMREAL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68924?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":75,"top_cate":"xls","bg_title":"巧用IMREAL函数 提取复数的实系数"},"channel":1,"app":"","version":1},{"key":"IMSIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67512?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"IMSIN函数 快速计算复数正弦值"},"channel":1,"app":"","version":1},{"key":"IMSQRT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67680?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"巧用IMSQRT函数 计算复数的平方根"},"channel":1,"app":"","version":1},{"key":"IMSUB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70722?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"巧用IMSUB函数 1秒求复数的差"},"channel":1,"app":"","version":1},{"key":"IMSUM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70721?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"巧用IMSUM函数 1秒求复数的和"},"channel":1,"app":"","version":1},{"key":"INDEX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70700?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":138,"top_cate":"xls","bg_title":"INDEX函数的用法"},"channel":1,"app":"","version":1},{"key":"INDIRECT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70627?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"INDIRECT函数 引用单元格内容"},"channel":1,"app":"","version":1},{"key":"INFO","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69055?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"INFO函数 查询操作环境信息"},"channel":1,"app":"","version":1},{"key":"INT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70586?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":47,"top_cate":"xls","bg_title":"巧用INT函数 一秒求整"},"channel":1,"app":"","version":1},{"key":"INTERCEPT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69669?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"INTERCEPT函数"},"channel":1,"app":"","version":1},{"key":"IPMT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69503?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":124,"top_cate":"xls","bg_title":"巧用IPMT函数计算贷款利息"},"channel":1,"app":"","version":1},{"key":"IRR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70612?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":85,"top_cate":"xls","bg_title":"巧用IRR函数 算内部收益率"},"channel":1,"app":"","version":1},{"key":"ISBLANK","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70485?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":57,"top_cate":"xls","bg_title":"ISBLANK函数 快速查看单元格空格"},"channel":1,"app":"","version":1},{"key":"ISERR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67237?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":91,"top_cate":"xls","bg_title":"ISERR与IF 一步去除错误字符"},"channel":1,"app":"","version":1},{"key":"ISERROR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70616?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"ISERROR函数 判断数值是否错误"},"channel":1,"app":"","version":1},{"key":"ISEVEN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69496?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"巧用ISEVEN函数 判断数值是否偶数"},"channel":1,"app":"","version":1},{"key":"ISFORMULA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13451?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"ISFORMULA函数"},"channel":1,"app":"","version":2},{"key":"ISLOGICAL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68935?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"ISLOGICAL函数 检验逻辑值"},"channel":1,"app":"","version":1},{"key":"ISNA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70593?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":56,"top_cate":"xls","bg_title":"巧用ISNA函数 处理错误值#N\/A"},"channel":1,"app":"","version":1},{"key":"ISNONTEXT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69008?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"ISNONTEXT函数 检验值是否为非文本"},"channel":1,"app":"","version":1},{"key":"ISNUMBER","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70591?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"ISNUMBER 一秒判断是否是数值"},"channel":1,"app":"","version":1},{"key":"ISODD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69884?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"ISODD函数判断数值奇偶 "},"channel":1,"app":"","version":1},{"key":"ISPMT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68870?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":99,"top_cate":"xls","bg_title":"ISPMT函数计算 特定投资期要支付利息"},"channel":1,"app":"","version":1},{"key":"ISREF","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69144?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"ISREF函数判断 值是否为单元格引用"},"channel":1,"app":"","version":1},{"key":"ISTEXT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69478?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"ISTEXT函数 检测参数是否为文本"},"channel":1,"app":"","version":1},{"key":"KURT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69353?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":41,"top_cate":"xls","bg_title":"KURT函数 计算数值峰值"},"channel":1,"app":"","version":1},{"key":"LAMBDA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/18150?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":176,"top_cate":"xls","bg_title":"LAMBDA函数使用技巧"},"channel":1,"app":"","version":2},{"key":"LARGE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70002?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":110,"top_cate":"xls","bg_title":"LARGE函数"},"channel":1,"app":"","version":1},{"key":"LCM","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/425.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":67,"show_type":"icon","top_cate":"xls","bg_title":"LCM函数 计算最小公倍数"},"channel":1,"app":"","version":1},{"key":"LEFT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70698?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":81,"top_cate":"xls","bg_title":"LEFT函数 一秒提取地址信息"},"channel":1,"app":"","version":1},{"key":"LEFTB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70719?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"巧用LEFTB函数 提取字节个数"},"channel":1,"app":"","version":1},{"key":"LEN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70035?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":51,"top_cate":"xls","bg_title":"LEN函数 计算文本字符"},"channel":1,"app":"","version":1},{"key":"LENB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70034?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"LENB函数 计算文本字节数"},"channel":1,"app":"","version":1},{"key":"LET","value":{"url":"https:\/\/bbs.wps.cn\/topic\/18151?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"LET函数使用技巧"},"channel":1,"app":"et","version":1},{"key":"LINEST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70196?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"LINEST函数 求斜率和截距"},"channel":1,"app":"","version":1},{"key":"LN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69352?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":47,"top_cate":"xls","bg_title":"LN函数 计算指定数值的自然对数"},"channel":1,"app":"","version":1},{"key":"LOG","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67275?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"巧用LOG函数 按指定底数返回对数"},"channel":1,"app":"","version":1},{"key":"LOG10","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68930?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"巧用LOG10函数 求数值以10为底的对数"},"channel":1,"app":"","version":1},{"key":"LOGEST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69014?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":79,"top_cate":"xls","bg_title":"LOGEST函数 计算回归拟合曲线值"},"channel":1,"app":"","version":1},{"key":"LOGINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70585?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":83,"top_cate":"xls","bg_title":"巧用LOGINV函数 求反函数值"},"channel":1,"app":"","version":1},{"key":"LOGNORMDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67261?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"LOGNORMDIST函数"},"channel":1,"app":"","version":1},{"key":"LOOKUP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70684?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":136,"top_cate":"xls","bg_title":"巧用LOOKUP函数 快速查找数据"},"channel":1,"app":"","version":1},{"key":"LOWER","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68874?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":71,"top_cate":"xls","bg_title":"巧用LOWER函数 一键转换英文大小写"},"channel":1,"app":"","version":1},{"key":"MATCH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70621?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":103,"top_cate":"xls","bg_title":"MATCH函数的作用"},"channel":1,"app":"","version":1},{"key":"MAX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70608?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":51,"top_cate":"xls","bg_title":"巧用MAX函数 一秒找到最大数值"},"channel":1,"app":"","version":1},{"key":"MAXA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69141?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":78,"top_cate":"xls","bg_title":"MAXA函数 计算数值的最大值"},"channel":1,"app":"","version":1},{"key":"MAXIFS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67674?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"巧用MAXIFS函数 按条件求最大值"},"channel":1,"app":"","version":1},{"key":"MDETERM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69678?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"MDETERM函数 快速求矩阵行列式的值"},"channel":1,"app":"","version":1},{"key":"MDURATION","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13447?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":108,"top_cate":"xls","bg_title":"MDURATION函数"},"channel":1,"app":"","version":2},{"key":"MEDIAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70038?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":47,"top_cate":"xls","bg_title":"MEDIAN函数 快速找到中位数"},"channel":1,"app":"","version":1},{"key":"MID","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70620?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":76,"top_cate":"xls","bg_title":"巧用MID函数 一秒提取身份证年月日"},"channel":1,"app":"","version":1},{"key":"MIDB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70027?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":93,"top_cate":"xls","bg_title":"巧用文本函数MIDB 截取指定字符"},"channel":1,"app":"","version":1},{"key":"MIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69692?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":38,"top_cate":"xls","bg_title":"MIN函数 一秒查找最小值"},"channel":1,"app":"","version":1},{"key":"MINA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69142?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":93,"top_cate":"xls","bg_title":"MINA函数 计算数值的最小值"},"channel":1,"app":"","version":1},{"key":"MINIFS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67514?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"巧用MINIFS函数 按条件求最小值"},"channel":1,"app":"","version":1},{"key":"MINUTE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70484?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"MINUTE函数 两个时间段分钟时长"},"channel":1,"app":"","version":1},{"key":"MINVERSE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70026?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":75,"top_cate":"xls","bg_title":"MINVERSE函数 求逆矩阵行列式"},"channel":1,"app":"","version":1},{"key":"MIRR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69670?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"MIRR函数计算 再投资的收益率"},"channel":1,"app":"","version":1},{"key":"MMULT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70555?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":88,"top_cate":"xls","bg_title":"MMULT函数 计算矩阵乘积"},"channel":1,"app":"","version":1},{"key":"MOD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70564?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":79,"top_cate":"xls","bg_title":"巧用MOD函数 求除法余数"},"channel":1,"app":"","version":1},{"key":"MODE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69007?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"巧用MODE函数 快速求众数"},"channel":1,"app":"","version":1},{"key":"MONTH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70584?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":64,"top_cate":"xls","bg_title":"MONTH函数 提取日期的月份值"},"channel":1,"app":"","version":1},{"key":"MROUND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69689?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":52,"top_cate":"xls","bg_title":"MROUND函数 舍入数值最近倍数"},"channel":1,"app":"","version":1},{"key":"MULTINOMIAL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69001?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":44,"top_cate":"xls","bg_title":"MULTINOMIAL函数"},"channel":1,"app":"","version":1},{"key":"N","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15320?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"N函数将非数值 转换成数值"},"channel":1,"app":"","version":1},{"key":"NA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69695?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"NA函数美化折线图 "},"channel":1,"app":"","version":1},{"key":"NEGBINOMDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68800?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"NEGBINOMDIST函数"},"channel":1,"app":"","version":1},{"key":"NETWORKDAYS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70569?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":74,"top_cate":"xls","bg_title":"NETWORKDAYS函数"},"channel":1,"app":"","version":1},{"key":"NETWORKDAYS.INTL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70098?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":86,"top_cate":"xls","bg_title":"NETWORKDAYS.INTL函数"},"channel":1,"app":"","version":1},{"key":"NORM.DIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15336?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"NORM.DIST函数"},"channel":1,"app":"","version":1},{"key":"NORM.INV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15335?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"NORM.INV函数"},"channel":1,"app":"","version":1},{"key":"NORM.S.DIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15334?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"NORM.S.DIST函数"},"channel":1,"app":"","version":1},{"key":"NORM.S.INV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15332?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"NORM.S.INV函数"},"channel":1,"app":"","version":1},{"key":"NORMDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70104?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":91,"top_cate":"xls","bg_title":"NORMDIST函数"},"channel":1,"app":"","version":1},{"key":"NORMINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70554?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"巧用NORMINV函数 求反函数值"},"channel":1,"app":"","version":1},{"key":"NORMSDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67259?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"NORMSDIST函数"},"channel":1,"app":"","version":1},{"key":"NORMSINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67252?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"NORMSINV函数计算"},"channel":1,"app":"","version":1},{"key":"NOT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68912?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":76,"top_cate":"xls","bg_title":"NOT函数反向判断 事物是否满足条件"},"channel":1,"app":"","version":1},{"key":"NOW","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69667?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"NOW函数插入 实时时间并自动更新"},"channel":1,"app":"","version":1},{"key":"NPER","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69431?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"NPER函数计算贷款总期数"},"channel":1,"app":"","version":1},{"key":"NPV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70614?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":70,"top_cate":"xls","bg_title":"巧用NPV函数 一秒计算收支净额"},"channel":1,"app":"","version":1},{"key":"NUMBERSTRING","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69140?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":101,"top_cate":"xls","bg_title":"NUMBERSTRING函数"},"channel":1,"app":"","version":1},{"key":"NUMBERVALUE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15317?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"NUMBERVALUE函数"},"channel":1,"app":"","version":2},{"key":"OCT2BIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70720?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":103,"top_cate":"xls","bg_title":"如何将八进制数 快捷转换成二进制数"},"channel":1,"app":"","version":1},{"key":"OCT2DEC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67684?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":53,"top_cate":"xls","bg_title":"OCT2DEC函数 八进制数转换十进制数"},"channel":1,"app":"","version":1},{"key":"OCT2HEX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67569?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"OCT2HEX函数 八进制转十六进制"},"channel":1,"app":"","version":1},{"key":"ODD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69358?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":76,"top_cate":"xls","bg_title":"ODD函数将数值 向上舍入为最接近的奇数"},"channel":1,"app":"","version":1},{"key":"OFFSET","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70623?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":174,"top_cate":"xls","bg_title":"如何使用OFFSET函数"},"channel":1,"app":"","version":1},{"key":"OR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70626?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":94,"top_cate":"xls","bg_title":"帮助你快速进行 逻辑判断的OR函数"},"channel":1,"app":"","version":1},{"key":"PEARSON","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69492?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"PEARSON函数 自变量因变量相关系数"},"channel":1,"app":"","version":1},{"key":"PERCENTILE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70203?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"PERCENTILE 求数组百分点"},"channel":1,"app":"","version":1},{"key":"PERCENTRANK","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67250?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":79,"top_cate":"xls","bg_title":"PERCENTRANK函数"},"channel":1,"app":"","version":1},{"key":"PERCENTRANK.EXC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67066?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":65,"top_cate":"xls","bg_title":"PERCENTRANK.EXC 函数的用法"},"channel":1,"app":"","version":2},{"key":"PERMUT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69057?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":99,"top_cate":"xls","bg_title":"巧用PERMUT函数 计算排列数"},"channel":1,"app":"","version":1},{"key":"PHONETIC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70607?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"PHONETIC函数 链接非连贯的文本"},"channel":1,"app":"","version":1},{"key":"PI","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69671?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"巧用PI函数 计算圆周长和圆面积"},"channel":1,"app":"","version":1},{"key":"PMT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70556?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":91,"top_cate":"xls","bg_title":"PMT函数计算分期还款 每期额度"},"channel":1,"app":"","version":1},{"key":"POISSON","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67249?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":83,"top_cate":"xls","bg_title":"POISSON函数 泊松累积分布函数值"},"channel":1,"app":"","version":1},{"key":"POWER","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70096?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"POWER函数 如何进行乘幂计算"},"channel":1,"app":"","version":1},{"key":"PPMT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70036?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":109,"top_cate":"xls","bg_title":"PPMT函数计算 规定期间本金偿还额"},"channel":1,"app":"","version":1},{"key":"PRICE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/302.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":99,"show_type":"icon","top_cate":"xls","bg_title":"PRICE函数 计算债券发行价格"},"channel":1,"app":"","version":1},{"key":"PROB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68873?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":91,"top_cate":"xls","bg_title":"PROB函数计算 数值指定区间的概率"},"channel":1,"app":"","version":1},{"key":"PRODUCT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69699?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":56,"top_cate":"xls","bg_title":"巧用PRODUCT函数 进行乘积计算"},"channel":1,"app":"","version":1},{"key":"PROPER","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/303.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"PROPER函数转换 首字母大写其余小写"},"channel":1,"app":"","version":1},{"key":"PV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70039?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"巧用PV函数计算投资现值"},"channel":1,"app":"","version":1},{"key":"QUARTILE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70489?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":99,"top_cate":"xls","bg_title":"QUARTILE函数 求四分位数"},"channel":1,"app":"","version":1},{"key":"QUOTIENT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69687?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"舍去商小数的除法运算 QUOTIENT函数"},"channel":1,"app":"","version":1},{"key":"RADIANS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69870?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"RADIANS函数 将角度转换弧度"},"channel":1,"app":"","version":1},{"key":"RAND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70691?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":116,"top_cate":"xls","bg_title":"巧用RAND函数 自动生成随机数据"},"channel":1,"app":"","version":1},{"key":"RANDARRAY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/12535?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":144,"top_cate":"xls","bg_title":"用RANDARRAY函数 生成随机数组"},"channel":1,"app":"et","version":2},{"key":"RANDBETWEEN","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/181.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":60,"show_type":"icon","top_cate":"xls","bg_title":"RANDBETWEEN函数"},"channel":1,"app":"","version":1},{"key":"RANK","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70693?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":130,"top_cate":"xls","bg_title":"RANK函数使用方法"},"channel":1,"app":"","version":1},{"key":"RANK.AVG","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67672?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":98,"top_cate":"xls","bg_title":"RANK.AVG函数的 使用方法"},"channel":1,"app":"","version":1},{"key":"RANK.EQ","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/506.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":96,"show_type":"icon","top_cate":"xls","bg_title":"RANK.EQ函数的 使用方法"},"channel":1,"app":"","version":1},{"key":"RATE","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/214.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":87,"show_type":"icon","top_cate":"xls","bg_title":"巧用RATE函数求利率"},"channel":1,"app":"","version":1},{"key":"REGEXP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/40929?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":128,"top_cate":"xls","bg_title":"REGEXP函数的用法"},"channel":1,"app":"et","version":1},{"key":"REPLACE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69426?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"REPLACE函数 替换新旧字符"},"channel":1,"app":"","version":1},{"key":"REPLACEB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15319?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":107,"top_cate":"xls","bg_title":"REPLACEB函数 批量更正错误数据"},"channel":1,"app":"","version":1},{"key":"REPT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70004?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"巧用REPT函数复制文本"},"channel":1,"app":"","version":1},{"key":"RIGHT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70037?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":43,"top_cate":"xls","bg_title":"巧用RIGHT函数 截取后段字符"},"channel":1,"app":"","version":1},{"key":"RIGHTB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69427?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":76,"top_cate":"xls","bg_title":"巧用RIGHTB函数 截取后段字符"},"channel":1,"app":"","version":1},{"key":"RMB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15321?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"RMB函数将数值 转换成货币"},"channel":1,"app":"","version":1},{"key":"ROMAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69004?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":58,"top_cate":"xls","bg_title":"ROMAN函数 将数值转换成罗马数字"},"channel":1,"app":"","version":1},{"key":"ROUND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70697?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":124,"top_cate":"xls","bg_title":"如何快捷对小数 进行四舍五入"},"channel":1,"app":"","version":1},{"key":"ROUNDDOWN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69668?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":87,"top_cate":"xls","bg_title":"ROUNDDOWN函数"},"channel":1,"app":"","version":1},{"key":"ROUNDUP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70494?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":62,"top_cate":"xls","bg_title":"ROUNDUP函数 向上舍入小数"},"channel":1,"app":"","version":1},{"key":"ROW","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70618?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":123,"top_cate":"xls","bg_title":"巧用ROW函数 快速标注序数"},"channel":1,"app":"","version":1},{"key":"ROWS","value":{"url":"https:\/\/www.wps.cn\/learning\/course\/detail\/id\/250.html?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"gif_url":"","pic_url":"","video_duration":44,"show_type":"icon","top_cate":"xls","bg_title":"ROWS函数 计算单元格行数"},"channel":1,"app":"","version":1},{"key":"RSQ","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69006?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"RSQ函数计算 乘积矩相关系数平方"},"channel":1,"app":"","version":1},{"key":"RTD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69685?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":108,"top_cate":"xls","bg_title":"巧用RTD函数 获取实时数据"},"channel":1,"app":"","version":1},{"key":"SEARCH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70566?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":87,"top_cate":"xls","bg_title":"SEARCH函数 查找字符首次出现位置"},"channel":1,"app":"","version":1},{"key":"SEARCHB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69886?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"SEARCHB函数查找 指定字节所在位置"},"channel":1,"app":"","version":1},{"key":"SECOND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69367?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"SECOND函数 提取时间秒数"},"channel":1,"app":"","version":1},{"key":"SEQUENCE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13060?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":122,"top_cate":"xls","bg_title":"如何使用 SEQUENCE函数"},"channel":1,"app":"et","version":2},{"key":"SERIESSUM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69693?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":90,"top_cate":"xls","bg_title":"SERIESSUM函数 计算幂级数之和"},"channel":1,"app":"","version":1},{"key":"SIGN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68906?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"巧用SIGN函数 检验数值正负性"},"channel":1,"app":"","version":1},{"key":"SIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70587?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"SIN函数 一秒计算正弦值"},"channel":1,"app":"","version":1},{"key":"SINH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68908?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"SINH函数 快速计算双曲正弦值"},"channel":1,"app":"","version":1},{"key":"SKEW","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69424?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":53,"top_cate":"xls","bg_title":"SKEW函数 快速计算偏斜度"},"channel":1,"app":"","version":1},{"key":"SLN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69663?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"巧用SLN函数计算 线性折旧值"},"channel":1,"app":"","version":1},{"key":"SLOPE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70099?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"SLOPE函数 计算线性回归线斜率"},"channel":1,"app":"","version":1},{"key":"SMALL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70567?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"巧用SMALL函数 查找数据集的最小值"},"channel":1,"app":"","version":1},{"key":"SORT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13057?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":205,"top_cate":"xls","bg_title":"SORT函数的 使用方法"},"channel":1,"app":"et","version":2},{"key":"SORTBY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13056?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":124,"top_cate":"xls","bg_title":"SORTBY函数 多条件排序"},"channel":1,"app":"et","version":2},{"key":"SQRT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70565?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":60,"top_cate":"xls","bg_title":"巧用SQRT函数 求平方根值"},"channel":1,"app":"","version":1},{"key":"SQRTPI","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69060?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"巧用SQRTPI函数 求乘以π后的平方根"},"channel":1,"app":"","version":1},{"key":"STANDARDIZE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67730?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":72,"top_cate":"xls","bg_title":"STANDARDIZE函数"},"channel":1,"app":"","version":1},{"key":"STDEV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70100?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":93,"top_cate":"xls","bg_title":"巧用STDEV函数 计算样本标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEV.S","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69500?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":83,"top_cate":"xls","bg_title":"STDEV.S函数 计算样本标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEVA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69354?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"STDEVA函数估算 文本逻辑的标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEVP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69875?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"STDEVP函数 计算样本标准偏差"},"channel":1,"app":"","version":1},{"key":"STDEVPA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68934?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":99,"top_cate":"xls","bg_title":"STDEVPA函数 计算样本总体标准偏差"},"channel":1,"app":"","version":1},{"key":"STEYX","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69005?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":75,"top_cate":"xls","bg_title":"巧用STEYX函数 估算标准误差值"},"channel":1,"app":"","version":1},{"key":"SUBSTITUTE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70603?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":86,"top_cate":"xls","bg_title":"SUBSTITUTE函数"},"channel":1,"app":"","version":1},{"key":"SUBTOTAL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70590?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":103,"top_cate":"xls","bg_title":"SUBTOTAL函数计算 包含或忽略隐藏的数值"},"channel":1,"app":"","version":1},{"key":"SUM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70610?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":145,"top_cate":"xls","bg_title":"常用求和函数 SUM函数"},"channel":1,"app":"","version":1},{"key":"SUMIF","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70686?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":262,"top_cate":"xls","bg_title":"常用条件求和函数 SUMIF函数"},"channel":1,"app":"","version":1},{"key":"SUMIFS","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70613?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"巧用SUMIFS函数 多条件求和"},"channel":1,"app":"","version":1},{"key":"SUMPRODUCT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70696?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":116,"top_cate":"xls","bg_title":"快速统计产品 销售总额以及总量"},"channel":1,"app":"","version":1},{"key":"SUMSQ","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69002?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":52,"top_cate":"xls","bg_title":"SUMSQ函数 计算数值平方和"},"channel":1,"app":"","version":1},{"key":"SUMX2MY2","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68797?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":77,"top_cate":"xls","bg_title":"SUMX2MY2函数 两数组对应值平方差之和"},"channel":1,"app":"","version":1},{"key":"SUMX2PY2","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67724?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":79,"top_cate":"xls","bg_title":"SUMX2PY2函数"},"channel":1,"app":"","version":1},{"key":"SUMXMY2","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68926?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":82,"top_cate":"xls","bg_title":"SUMXMY2函数"},"channel":1,"app":"","version":1},{"key":"SWITCH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67235?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":109,"top_cate":"xls","bg_title":"SWITCH函数 定义某个值匹配对应结果"},"channel":1,"app":"","version":1},{"key":"SYD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69363?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":98,"top_cate":"xls","bg_title":"SYD函数计算折旧值 （年数总和法）"},"channel":1,"app":"","version":1},{"key":"T","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69872?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":61,"top_cate":"xls","bg_title":"巧用T函数 提取文本数据"},"channel":1,"app":"","version":1},{"key":"TAKE","value":{"url":"https:\/\/home.wps.cn\/topic\/14676?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":56,"top_cate":"xls","bg_title":"TAKE从数组开头或结尾返回对应的行或列数据"},"channel":1,"app":"et","version":1},{"key":"TAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70031?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"巧用TAN函数 求正切值"},"channel":1,"app":"","version":1},{"key":"TANH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68799?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":69,"top_cate":"xls","bg_title":"TANH函数 快速计算双曲正切值"},"channel":1,"app":"","version":1},{"key":"TDIST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67246?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":81,"top_cate":"xls","bg_title":"TDIST函数 计算学生T分布的概率"},"channel":1,"app":"","version":1},{"key":"TEXT","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70625?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":140,"top_cate":"xls","bg_title":"一定要学 强大的转换函数TEXT"},"channel":1,"app":"","version":1},{"key":"TEXTJOIN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69873?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"TEXTJOIN函数 更强大的合并文本函数"},"channel":1,"app":"","version":1},{"key":"TIME","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70030?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"巧用TIME函数表示时间"},"channel":1,"app":"","version":1},{"key":"TIMEVALUE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69662?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":94,"top_cate":"xls","bg_title":"TIMEVALUE函数 计算员工加班时间"},"channel":1,"app":"","version":1},{"key":"TINV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69063?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":73,"top_cate":"xls","bg_title":"TINV函数计算 自由度双尾概率区间点"},"channel":1,"app":"","version":1},{"key":"TOCOL","value":{"url":"https:\/\/home.wps.cn\/topic\/14678?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":63,"top_cate":"xls","bg_title":"TOCOL多行多列转一列"},"channel":1,"app":"et","version":1},{"key":"TODAY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70493?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"TODAY函数快速 计算间隔天数"},"channel":1,"app":"","version":1},{"key":"TOROW","value":{"url":"https:\/\/home.wps.cn\/topic\/14679?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":95,"top_cate":"xls","bg_title":"TOROW多行多列转一行"},"channel":1,"app":"et","version":1},{"key":"TRANSPOSE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68932?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":75,"top_cate":"xls","bg_title":"TRANSPOSE函数 转置表格横行竖列"},"channel":1,"app":"","version":1},{"key":"TREND","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70029?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":82,"top_cate":"xls","bg_title":"TREND函数 预测线性增长值"},"channel":1,"app":"","version":1},{"key":"TRIM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70496?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"巧用TRIM函数清除 字符首尾空格"},"channel":1,"app":"","version":1},{"key":"TRIMMEAN","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70149?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":82,"top_cate":"xls","bg_title":"TRIMMEAN函数 求平均值"},"channel":1,"app":"","version":1},{"key":"TRUE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69370?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"TRUE函数 判断条件是否成立"},"channel":1,"app":"","version":1},{"key":"TRUNC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70199?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":54,"top_cate":"xls","bg_title":"TRUNC函数 截去数字小数部分"},"channel":1,"app":"","version":1},{"key":"TTEST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70583?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":85,"top_cate":"xls","bg_title":"巧用TTEST函数 运算T检验"},"channel":1,"app":"","version":1},{"key":"TYPE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69373?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"巧用TYPE函数 检验数值类型"},"channel":1,"app":"","version":1},{"key":"UNIQUE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13044?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":178,"top_cate":"xls","bg_title":"使用UNIQUE函数 去除重复项"},"channel":1,"app":"et","version":2},{"key":"UPPER","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67727?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"巧用UPPER函数 一键转换英文大小写"},"channel":1,"app":"","version":1},{"key":"VALUE","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67228?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":45,"top_cate":"xls","bg_title":"VALUE函数将 数字文本转换成数值"},"channel":1,"app":"","version":1},{"key":"VAR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69368?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":71,"top_cate":"xls","bg_title":"VAR函数 计算样本数据的方差"},"channel":1,"app":"","version":1},{"key":"VAR.P","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15325?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":49,"top_cate":"xls","bg_title":"VAR.P函数"},"channel":1,"app":"","version":1},{"key":"VAR.S","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15323?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":50,"top_cate":"xls","bg_title":"VAR.S函数"},"channel":1,"app":"","version":1},{"key":"VARA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68914?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":59,"top_cate":"xls","bg_title":"VARA函数 计算样本方差"},"channel":1,"app":"","version":1},{"key":"VARP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69364?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":76,"top_cate":"xls","bg_title":"VARP函数 计算总体样本数据方差"},"channel":1,"app":"","version":1},{"key":"VARPA","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67755?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":44,"top_cate":"xls","bg_title":"VARPA函数 计算样本总体方差"},"channel":1,"app":"","version":1},{"key":"VDB","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69003?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":68,"top_cate":"xls","bg_title":"VDB函数计算 给定期间的折旧值"},"channel":1,"app":"","version":1},{"key":"VLOOKUP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70717?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":103,"top_cate":"xls","bg_title":"VLOOKUP函数 查询指定条件的结果"},"channel":1,"app":"","version":1},{"key":"VSTACK","value":{"url":"https:\/\/home.wps.cn\/topic\/14680?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":44,"top_cate":"xls","bg_title":"VSTACK垂直方向拼接数据"},"channel":1,"app":"et","version":1},{"key":"WEEKDAY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68867?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":92,"top_cate":"xls","bg_title":"WEEKDAY函数 判断星期几"},"channel":1,"app":"","version":1},{"key":"WEEKNUM","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70562?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":90,"top_cate":"xls","bg_title":"WEEKNUM函数 计算学期周数"},"channel":1,"app":"","version":1},{"key":"WEIBULL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/68907?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":107,"top_cate":"xls","bg_title":"WEIBULL函数 快速计算韦布尔分布"},"channel":1,"app":"","version":1},{"key":"WIDECHAR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67568?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":67,"top_cate":"xls","bg_title":"WIDECHAR函数 半角字符转全角字符"},"channel":1,"app":"","version":1},{"key":"WORKDAY","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70486?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":66,"top_cate":"xls","bg_title":"WORKDAY函数 统计员工离岗日期"},"channel":1,"app":"","version":1},{"key":"WORKDAY.INTL","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15315?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"WORKDAY.INTL函数"},"channel":1,"app":"","version":2},{"key":"WRAPCOLS","value":{"url":"https:\/\/home.wps.cn\/topic\/14681?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":41,"top_cate":"xls","bg_title":"WRAPCOLS将一维数据转换二维数据"},"channel":1,"app":"et","version":1},{"key":"WRAPROWS","value":{"url":"https:\/\/home.wps.cn\/topic\/14682?chan=pc_win_function","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":29,"top_cate":"xls","bg_title":"WRAPROWS将一维数据转化为二维数据"},"channel":1,"app":"et","version":1},{"key":"XIRR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69690?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"XIRR函数计算基金收益率"},"channel":1,"app":"","version":1},{"key":"XLOOKUP","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13048?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":551,"top_cate":"xls","bg_title":"XLOOKUP函数的 使用方法"},"channel":1,"app":"et","version":2},{"key":"XMATCH","value":{"url":"https:\/\/bbs.wps.cn\/topic\/13054?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":0,"show_type":"icon","gif_url":"","pic_url":"","video_duration":331,"top_cate":"xls","bg_title":"XMATCH函数的 使用方法"},"channel":1,"app":"et","version":2},{"key":"XNPV","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69366?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":81,"top_cate":"xls","bg_title":"XNPV函数计算 不定期收益项目净现值"},"channel":1,"app":"","version":1},{"key":"XOR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/15330?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":0,"top_cate":"xls","bg_title":"XOR函数"},"channel":1,"app":"","version":1},{"key":"YEAR","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70487?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":55,"top_cate":"xls","bg_title":"巧用YEAR函数 一秒提取年份"},"channel":1,"app":"","version":1},{"key":"YEARFRAC","value":{"url":"https:\/\/bbs.wps.cn\/topic\/69879?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":57,"top_cate":"xls","bg_title":"YEARFRAC函数 一段日期占全年日期比例"},"channel":1,"app":"","version":1},{"key":"YIELD","value":{"url":"https:\/\/bbs.wps.cn\/topic\/67504?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":115,"top_cate":"xls","bg_title":"YIELD函数计算 定期支付利息债券收益率"},"channel":1,"app":"","version":1},{"key":"ZTEST","value":{"url":"https:\/\/bbs.wps.cn\/topic\/70729?chan=pc_win_function25","show_signal":0,"has_video_icon":1,"show_signal_times":1,"show_type":"icon","gif_url":"","pic_url":"","video_duration":70,"top_cate":"xls","bg_title":"巧用WPS 快速算出ZTEST函数值"},"channel":1,"app":"","version":1}]}