天气预报15天查询> 其他> WPS中如何让负数自动变为零

WPS中如何让负数自动变为零

更新时间: 2020-10-02 00:00:00     

wps让负数自动变成零步骤:

1、将光标定位在需要的单元格中;

2、点击开始,选择求和,点击其他函数;

3、插入函数对话框,选择IF函数;

4、弹出函数参数对话框,在假值处输入不满足条件时显示的内容,输入0。

关键词: wps 如何 负数 自动 变为

如有意见、反馈、侵权或投诉等情况,请联系:

电话:
邮箱:

我们将会在48小时内给与处理!

版权所有 Copyright ? 2009-2020 tianqiyubao3.com

页面:/news/view-1797041/ | 耗时:0.0608 s | 内存:1.89 MB | 查询:4 | 缓存读取:4 写入:0 | 加载文件:23
select * from tbl_Articles WHERE ArticleID=1797041 LIMIT 0,1
select * from tbl_Articles_data WHERE ArticleID=1797041 LIMIT 0,1
select * from tbl_Articles_sphinx where id=1797041 LIMIT 0,1
SELECT ArticleID,Title FROM tbl_Articles WHERE ArticleID IN(1514504,748473,1123493,1068268,351387,114065,1609567,1073820,413731,3100713,1129153,394417,1092163,1041499,1130208,1847317,1565466,1548944,561047,1277549,1082954,1062130,1067910,2930474,1102206,1082173,658293,555405,583095,142538) ORDER BY field (ArticleID,1514504,748473,1123493,1068268,351387,114065,1609567,1073820,413731,3100713,1129153,394417,1092163,1041499,1130208,1847317,1565466,1548944,561047,1277549,1082954,1062130,1067910,2930474,1102206,1082173,658293,555405,583095,142538)