請問如可以取得整數值
如 126,000.00 = 126.00
126,100.00 = 127.00
請指教及給我該公式,謝謝!
EXCEL
2014-02-18 7:16 am
回答 (3)
2014-02-18 3:26 pm
✔ 最佳答案
=ROUNDUP(A1/1000,0)
格式化為小數2位
或
=TEXT(ROUNDUP(A1/1000,0),"0.00_ ")
2014-02-18 4:37 pm
=-INT(-A1/1000)
2014-02-18 8:47 am
A1 = 126,000.00
=ROUNDUP(A1/1000,10) 再配上 2 d.p.
=ROUNDUP(A1/1000,10) 再配上 2 d.p.
收錄日期: 2021-04-28 13:45:53
原文連結 [永久失效]:
https://hk.answers.yahoo.com/question/index?qid=20140217000010KK05640