Indlela yokujikeleza iinombolo eziphantsi kwe-Excel kunye nomsebenzi weROUNDDOWN

01 ngo 01

Umsebenzi weROUNDDOWN we-Excel

Umsebenzi weROUNDDOWN:

• isetyenziswe ukunciphisa ixabiso ngenani elithile leendawo zokugqibela okanye idijithi;
• Uya kuhlala egcina idijithi yokujikeleza ifanayo;
• iguqula ixabiso leedatha kwindlela yokwenza iifom yeefom yeefayile ezingafaniyo ezikuvumela ukuba utshintshe inani leendawo zokugqibela ezingabonakaliyo ngaphandle kokutshintsha ixabiso kwiseli;
• ichaphazela iziphumo zokubala ngenxa yolu tshintsho kwidatha.
• soloko ijikeleza ngokubhekiselele kuyo. Amanqaku angalunganga, nangona ayenyuka kwindleko ngomsebenzi, kuthiwa adibeneyo - njengoko kuboniswe kwimimiselo emiqolo emihlanu neyesithandathu kumfanekiso ongentla).

I-Syntax yeMisebenzi ye-ROUNDDOWN neeArguments

I- syntax yomsebenzi ibhekisela kwisakhiwo somsebenzi kwaye iquka igama lomsebenzi, amabakethi kunye neengxabano.

I-syntax yomsebenzi we-ROUNDDOWN ngu:

= ROUNDDOWN (Inani, Num_digits)

Iingxoxo zomsebenzi zi:

Inombolo - (efunekayo) ixabiso lokuhlaziywa

• Le ngxabano ingaba nedatha yangempela yokujikeleza okanye ingaba yereferensi yeseli kwendawo yedata kwiphepha lokusebenzela.

Num_digits - (efunekayo) inani lamadijithi apho idijithi yenombolo iya kubalwa.

• ukuba i- arg_digits ingqinisiso isetyenziswe ku-0, umsebenzi ujikeleza ixabiso ukuya kwi-integer esondeleyo
• Ukuba i- Num_digits ingqinisiso isetyenziswe ku-1, umsebenzi ushiya idijithi enye ukuya ngasekunene kwinqanaba lokugqibela kwaye ulijikeleze kwinombolo elandelayo
• ukuba i- Num_digits ingxabano ayinakwenzeka , zonke izithuba ezidlulileyo zisusiwe kwaye umsebenzi ojikelezayo unani lamadijithi ukuya kwesobunxele kwinqanaba lokugqibela ukuya kutsho
  • umzekelo, ukuba ixabiso le- Num_digits ingxabano isetyenziswe kwi-- 2 , umsebenzi uya kususa onke amadijithi ukuya ngasekunene kwinqanaba lokugqibela kwaye ujikeleze idijithi zokuqala neyesibini ukuya kwesobunxele be-decimal ukuya kwi-100 elisondeleyo njengoko kubonisiwe kumzekelo kumgca 6 kumfanekiso ongentla

Imisebenzi yeROUNDDOWN

Umfanekiso ongentla ungabonisa imizekelo kwaye unikeza inkcazo yeenombolo zeziphumo ezibuyiselwe ngumsebenzi we-ROUNDDOWN we-Excel wedatha kwikholam A yephepha lokusebenzela.

Iziphumo, eziboniswe kwikholam B, zixhomekeke kwixabiso le- Num_digits ingxabano .

Imiyalelo engezantsi iinkcukacha amanyathelo athathwe ukunciphisa inombolo kwiseli ye-A2 kumfanekiso ongentla kwiindawo ezimbini zokugqibela usebenzisa umsebenzi we-ROUNDDOWN. Ngenxa yokuba umsebenzi uhlala ujikeleza, umgca wokujikeleza awuyi kutshintsha.

Ukufaka umsebenzi weROUNDDOWN

Izinketho zokungena kumsebenzi kunye neengxabano zayo ziquka:

• Ukuthayipha umsebenzi opheleleyo: = ROUNDDOWN (A2,2) kwisitokisi C3 kwiphepha lokusebenzela;
• Ukukhetha umsebenzi kunye neengxabano usebenzisa ibhokisi yencoko yencoko yomsebenzi.

Ukusebenzisa ibhokisi yencoko yababini yenza lula ukungena kwiingxoxo zomsebenzi. Ngale ndlela, akukho imfuneko yokufaka ii-commas phakathi kwee-arguments of work as it should be done when the task is typed in a cell-in this case between A2 and 2.

Amanyathelo angezantsi angena kwi-ROUNDDOWN umsebenzi usebenzisa ibhokisi yencoko.

1. Cofa kwiseli C3 ukwenzela ukuba yenze iseli esebenzayo - yilapho iziphumo ze-ROUNDDOWN umsebenzi ziya kuboniswa;
2. Cofa kwiThebhu yefomula yemenyu yebhondi ;
3. Khetha i- Math & Trig kwi-ribbon ukuvula uluhlu lwehla lokuhla;
4. Cofa kwi- ROUNDDOWN kwoluhlu ukukhupha ibhokisi yencoko yencoko yomsebenzi;
5. Kwibhokisi yencoko qhosha kwiNombolo yomgca;
6. Cofa kwiseli A2 kwiphepha lokusebenzela ukufaka loo ntetho yeselenki kwibhokisi yencoko njengendawo yendawo yokudibana;
7. Cofa kwi- Num_digits line;
8. Thayipha ezimbini "2" ukwenzela ukunciphisa inani kwi-A2 ukusuka kwiindawo ezi-5 ukuya kwembini zedesimali;
9. Cofa OK ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela;
10. Impendulo 567.96 ifanele ivele kwiseli C3;
11. Xa ucofa kwiseli C2 umsebenzi opheleleyo = ROUNDDOWN (A2, 2) ibonakala kwifom yefomula ngaphezulu kwephepha lokusebenzela .