将Excel中的空值替换为零
问题描述：
在Excel工作表中，我正在上传一组数据.一些列没有任何值.如何用零替换空列?
In an excel sheet, I''m uploading a set of datas. Some of the columns are not having any values. How can I replace those column with null values by zero?
答
您可以使用ISBLANK().
如需更多帮助，请访问 http://excelhints.com/2007 /05/30/isna-iserror-and-isblank-formula-in-excel/ [
You can useISBLANK().
For more help, go through http://excelhints.com/2007/05/30/isna-iserror-and-isblank-formula-in-excel/[^].