請各位網友賜教
在excel中怎樣張負數的數值變作0，不顯示負數只顯示0
在excel中怎樣張負數的數值變作0，不顯示負數只顯示0
2007-06-24 6:37 am
回答 (2)
2007-06-24 7:22 am
✔ 最佳答案
o係你想顯示o個格打 =IF(B2 < 0," 0 ",B2) 或 按插入--> 函數, 選取函數 IFB2係你入數值o個格
解釋
IF: 若
B2<0: B2o個格少於0
" 0 ": 顯示0
B2: 顯示返B2o個格
2007-06-24 8:10 am
ctrl-1,, cell format,, custom,,
0;”0”;0
but are you sure this won't mislead the user !?
0;”0”;0
but are you sure this won't mislead the user !?
參考: give me 10 bugs..
收錄日期: 2021-05-01 00:25:57
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20070623000051KK04636