Linomoro tse nkiloeng ho isa ho linomoro tse itseng tse boletsoeng
Ka Excel, mosebetsi oa ROUND o sebelisetsoa ho pota linomoro ho ea ho linomoro tse itseng tse boletsoeng. E ka pota ka lehlakoreng le leng la boemo ba decimal. Ha e etsa sena, e fetola boleng ba data ka seleng-ho fapana le dikgetho tsa ho etsa mekhoa e lumellang hore u fetole palo ea libaka tsa boemo bo phahameng tse bontšitsoeng ntle le ho fetola boleng ka sele. Ka lebaka la phetoho ena ea data, mosebetsi oa ROUND o ama liphello tsa lipalo ka spreadsheet.
01 ea 02
Syntax ea Mesebetsi le Liqeto
Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang .
Tlhaloso ea mosebetsi oa ROUND ke:
= ROUND (Number, Num_digits)Lintlha tsa mosebetsi ke Numane le Num_digits:
Nomoro ke bohlokoa ba ho pota. Puisano ena e ka ba le data ea sebele ea ho pota-potia, kapa e ka ba selefouno ea sele ho sebaka sa data lefatseng la mosebetsi. Ke ntho e hlokahalang.
Num_digits ke palo ea linomoro tseo Palo ea Lintlha e tla litsoa. E boetse e hlokoa.
- Haeba kopano ea Num_digits e behiloe ho zero, tshebetso e potoloha boleng hodimo hodimo kapa ho tlase ho lekaneng le haufi.
- Haeba phallo ea Num_digits e kholo ho feta zero, boleng bo pota-potiloe ho palo e boletsoeng ea libaka tsa maemo.
- Haeba boleng ba khang ea Num_digits bo behiloe ho 2 , mosebetsi o tlohela litekanyetso tse peli ho ea ho lekaneng la ntlha ea bophara le ho potoloha nomoro ea ho qetela kapa ho ea tlase nomoro e latelang.
- Haeba ho lumellana ha Num_digit ho fosahetse, libaka tsohle tsa marang-rang li tlosoa 'me mosebetsi o potoloha kapa o theoha dipalo tsa palo eo ho ea ka letsohong le letšehali la ntlha ea decimal.
- Haeba boleng ba khang ea Num_digits bo behiloe ho 2 , mosebetsi o tlosa likhaolo tsohle ho ea ka ho lekana le ntlha ea bophahamo le ho potoloha likarolo tsa pele le tsa bobeli ho ea ka ho le letšehali ho tloha qetellong kapa ho ea ho tse 100 tse haufi.
Tlhokomeliso: Haeba kamehla u batla ho pota-pota linomoro, sebelisa mosebetsi oa ROUNDUP. Haeba kamehla u batla ho pota-pota linomoro, sebelisa mosebetsi oa ROUNDDOWN.
02 ea 02
Mokhoa oa ROUND Mohlala
Setšoantšo se tsamaeang le sehlooho sena se bonts'a mehlala ea liphetho tse ngata tse khutlisetsoang ke mosebetsi oa ROUND oa Excel bakeng sa dintlha tse ka holimo sa A ea leqephe.
Liphetho, tse bontsitsoeng kahare ea C, li itšetlehile ka bohlokoa ba khang ea Num_digits .
Dikgetho bakeng sa ho kenya mosebetsi oa ROUND
Ka mohlala, ho fokotsa palo ea 17.568 ka sele ea A5 setšoantšong ho libaka tse peli tsa decimal ho sebelisa mosebetsi oa ROUND, dikgetho tsa ho kena mosebetsing mme lintlha tsa eona li kenyeletsa:
- Tšoara mosebetsi o feletseng: = ROUND (A5,2) ho kenya seleng ea C5 kahare
- Ho khetha mosebetsi le mabaka ka lebokose la lebokose la mosebetsi .
Le hoja ho ka khoneha ho thaepa mosebetsi o feletseng ka letsoho, batho ba bangata ba fumana ho le bonolo ho sebelisa lebokose la lebokose ho kenya lintlha tse sebetsang.
Kamoo U ka Sebelisang Lebokose la Dialog
Bakeng sa mohlala ona, bula sesepa sa Excel mme u kenye litekanyetso ho karolo ea A ea setšoantšo ho ea ho lehlakoreng le melaetsa ea spreadsheet.
Ho sebelisa lebokose la lebokose ho kenya mosebetsi oa ROUND ka seleng ea C5:
- Tobetsa seleng ea C5 ho e etsa hore e be sele e sebetsang. Mona ke moo liphetho tsa mosebetsi oa ROUND li tla bonahala.
- Tobetsa Tlhahlobo ea temo ea menu.
- Khetha Math & Trig ho tloha leboneng ho bula lenane la ho theoha mosebetsing.
- Tobetsa ROUND ho lethathamong ho hlahisa lebokose la lebokose la mosebetsi.
- Ka lebokoseng la lebokose, tobetsa Nthong ea nomoro .
- Tobetsa seleng ea A5 kahare ea mosebetsi ho kenya lengolo leo la selefouno lebokoseng la lebokose.
- Tobetsa ho Num_digits line.
- Ngola 2 ho fokotsa boleng ho A5 ho isa ho libaka tse peli tsa decimal.
- Tobetsa OK ho koala lebokose la lebokose le ho khutlela mosebetsing.
Karabo ea 17.57 e lokela ho hlaha ka seleng ea C5. Ha o tobetsa seleng ea C5, mosebetsi o feletseng = ROUND (A5.2) o hlaha kahare ea foromo ka holim'a leqephe.
Lebaka leo mosebetsi oa ROUND o Khutlisitsoeng 17.57
Ho beha kakaretso ea khang ea Num_digits ho 2 ho fokotsa palo ea libaka tsa boemo ba karabo ho karabo ho tloha ho tse tharo ho isa ho tse peli. Hobane Num_digits e behiloeng ho 2, ea 6 palo ea 17.568 ke tekanyo ea ho pota.
Kaha bohlokoa ho ea ka ho le letona la nomoro ea palo-nomoro ea 8-e kholo ho feta 4, nomoro ea ho lekanngoa e eketseha ke e mong e fanang ka liphello tsa 17.57.