01 ea 01
Mosebetsi oa ROUNDDOWN oa Excel
Mosebetsi oa ROUNDDOWN:
- e sebelisetsoa ho fokotsa boleng ka palo e itseng ea libaka tsa boemo bo phahameng kapa litefiso;
- kamehla o tla boloka nomoro e lekanang le eona;
- e fetola boleng ba data ka seleng-ho fapana le dikgetho tsa ho etsa mekhoa e lumellang hore o fetole palo ea libaka tsa boemo bo phahameng tse bontšitsoeng ntle le ho fetola boleng ka sele;
- e ama liphello tsa lipalo ka lebaka la phetoho ena ho data.
- kamehla ho potoloha ho ea zero. Linomoro tse fosahetseng, le hoja li eketseha ka boleng ka ts'ebetso, li boleloa li fokotsoe - joalokaha ho bontšitsoe mehlaleng e mehlano le tse tšeletseng setšoantšong se ka holimo).
Syntax ea Funso ea ROUNDDOWN le Arguments
Syntax ea mosebetsi e bua ka boemo ba mosebetsi mme o kenyelletsa lebitso la mosebetsi, li-brackets le likhang.
Tlhaloso ea mosebetsi oa ROUNDDOWN ke:
= ROUNDDOWN (Nomoro, Num_digits)
Likhopolo tsa mosebetsi ke:
Nomoro - (e hlokahalang) bohlokoa ba ho pota
- Khang ena e ka ba le data ea sebele ea ho pota kapa e ka ba selefouno ea sele ho sebaka sa data lefatseng la mosebetsi.
Num_digits - (e hlokehang) palo ea linomoro tseo Palo ea linomoro e tla etsoa ho tsona.
- haeba Num_digits khang e behoa ho 0, mosebetsi o potoloha boleng ho ea ho lekaneng le haufi
- haeba Num_digits khang e behiloe ho 1, mosebetsi o siea nomoro e le 'ngoe feela ho le letona la ntlha ea bophahamo ebe e pota ho ea nomoro e hlahlamang
- haeba Num_digits khang e fosahetse, libaka tsohle tsa marang-rang li tlosoa 'me mosebetsi o pota-pota dipalo tse lekaneng ho ea ka letsohong le letšehali ho fihlela ho ea holimo
- mohlala, haeba boleng ba khang ea Num_digits bo behiloe ho -2 , mosebetsi o tla tlosa likhau tsohle ho ea ka ho le letona la ntlha ea bophahamo ebe o pota likarolo tsa pele le tsa bobeli ho ea ka ho le letšehali ho tloha ho decimal ho ea ho tse 100 tse haufi joalokaha ho bontšitsoe ka mohlala o mothating oa 6 setšoantšong se ka holimo
Mesebetsi ea ROUNDDOWN Examples
Setšoantšo se ka holimo se hlahisa mehlala 'me se fana ka litlhaloso tsa liphetho tse ngata tse khutlisetsoang ke mosebetsi oa ROUNDDOWN oa Excel bakeng sa dintlha ho karolo ea A ea mosebetsi.
Liphetho, tse bontsitsoeng kahare ea B, li itšetlehile ka bohlokoa ba khang ea Num_digits .
Melao e ka tlaase e qaqileng mehato e nkiloeng ho fokotsa palo ka seleng ea A2 setšoantšong se ka holimo ho libaka tse peli tsa decimal ho sebelisa mosebetsi oa ROUNDDOWN. Hobane mosebetsi o ntse o pota-pota, nomoro ea ho potoloha e ke ke ea fetoha.
Ho kenya mosebetsi oa ROUNDDOWN
Dikgetho bakeng sa ho kena mosebetsing le mabaka a eona a kenyeletsa:
- Tšoaea mosebetsi o feletseng: = ROUNDDOWN (A2.2) ho kenya seleng ea C3 kahare ea mosebetsi;
- Ho khetha mosebetsi le mabaka ka lebokose la lebokose la mosebetsi .
Ho sebelisa lebokose la lihlooho ho nolofalletsa ho kena litabeng tsa mosebetsi. Ka mokhoa ona, ha ho hlokahale hore u kenye liphahlo pakeng tsa lintlha tsohle tsa ts'ebetso eo ho lokelang ho etsoa ha mosebetsi o kenngoa seleng - tabeng ena pakeng tsa A2 le 2.
Mehato e ka tlaase e koahelang ho kena mosebetsing oa ROUNDDOWN u sebelisa lebokose la lebokose.
- Tobetsa ho cell C3 ho e etsa hore e be sele e sebetsang - ena ke moo liphetho tsa mosebetsi oa ROUNDDOWN li tla bontšoa;
- Tobetsa Tlhahlobo ea temo ea menu;
- Khetha Math & Trig ho tloha leboneng ho bula lenane la ho theoha mosebetsing;
- Tlanya ho ROUNDDOWN lenaneng ho hlahisa lebokose la lebokose la mosebetsi;
- Ka lebokoseng la lebokose, tobetsa ho Nthane ea Nomoro ;
- Tobetsa ho seleng ea A2 leqepheng la mosebetsi oa ho kenya lengolo le lengolo la lebokoseng la lebokose le le leng la sebaka sa palo;
- Tobetsa ho Num_digits line;
- Ngola tse peli "2" ho fokotsa palo ho A2 ho tloha libakeng tse hlano ho isa ho tse peli tsa maraka;
- Tobetsa OK ho koala lebokose la lebokose mme u khutlele mosebetsing;
- Karabo 567.96 e lokela ho hlaha ka seleng ea C3;
- Ha o tobetsa seleng ea C2 mosebetsi o feletseng = ROUNDDOWN (A2, 2) e hlaha kahare ea foromo ka holim'a leqephe .