請問如可以取得整數值
如 126,000.00 = 126.00
126,100.00 = 127.00
請指教及給我該公式,謝謝!
=ROUNDUP(A1/1000,0)
格式化為小數2位
或
=TEXT(ROUNDUP(A1/1000,0),"0.00_ ")
=-INT(-A1/1000)
A1 = 126,000.00
=ROUNDUP(A1/1000,10) 再配上 2 d.p.
Copyright © 2024 Q2A.ES - All rights reserved.
Answers & Comments
Verified answer
=ROUNDUP(A1/1000,0)
格式化為小數2位
或
=TEXT(ROUNDUP(A1/1000,0),"0.00_ ")
=-INT(-A1/1000)
A1 = 126,000.00
=ROUNDUP(A1/1000,10) 再配上 2 d.p.