Ungawusondeza kanjani umphumela ku-Excel - amafomula

Enye yezinqubo zezibalo ezidumile abantu abavame ukuzisebenzisa lapho besebenza namaspredishithi e-Excel izinombolo zokusondeza. Abanye abasaqalayo bazama ukusebenzisa ifomethi yenombolo, kodwa ayakhelwe ukubonisa izinombolo eziqondile kumaseli, okuholela emaphutheni. Ukuze uthole umphumela oyifunayo ngemva kokuhlanganisa, kufanele usebenzise imisebenzi ekhethekile eyenzelwe lokhu kusebenza kwezibalo. Udinga ukwazi ngamunye wabo ngokuningiliziwe.

Umsebenzi ongu-round

Umsebenzi olula ongahlanganisa ngawo inani lenombolo enani elidingekayo lamadijithi ngu-ROUND. Isibonelo esilula ukusondeza idesimali kusuka ezindaweni ezimbili zedesimali kuya kweyodwa.

Kubalulekile ukukhumbula ukuthi lo msebenzi uzungeza kuphela ukusuka ku-zero.

Ukubukeka kwefomula ethi RUND: Umjikelezo(inombolo, inombolo yamadijithi). Ukunwetshwa kwengxabano:

1. Inombolo yamadijithi - lapha kufanele ucacise inani lamadijithi lapho inani lezinombolo lizofinyezwa khona.
2. Inombolo - le ndawo ingaba inani lenombolo, ingxenyenamba yedesimali, ezofinyezwa.

Inombolo yamadijithi ingaba:

• okungalungile - kulokhu, ingxenye ephelele kuphela yenani lezinombolo (ekwesokunxele sephuzu ledesimali) iyindilinga;
• elilingana noziro - wonke amadijithi afinyezwa engxenyeni ephelele;
• i-positive - kulesi simo, ingxenye ye-fractional kuphela, engakwesokudla kwephuzu ledesimali, iyindilinga.

Izindlela zokusetha:

1. Ukuze uthole inombolo ifinyezwe ibe okweshumi njengomphumela, udinga ukuvula iwindi ngokusetha izimpikiswano zomsebenzi, faka inani elithi "1" emgqeni "wenombolo yamadijithi".
2. Ukuze ufinyeze inani lenombolo libe kumakhulukhulu, udinga ukufaka inani elithi “2” efasiteleni lezilungiselelo zezimpikiswano zomsebenzi.
3. Ukuze uthole inani lenombolo elifinyezwe enkulungwaneni eseduze, efasiteleni lokusetha izimpikiswano emgqeni "inombolo yamadijithi" kufanele ufake inombolo "3".

Imisebenzi ye-RoundUP kanye ne-ROUNDDOWN

Amanye amafomula amabili aklanyelwe ukuzungeza amanani ezinombolo ku-Excel athi ROUNDUP kanye ne-ROUNDDOWN. Ngosizo lwabo, ungakwazi ukuzungeza izinombolo eziyingxenyeni phezulu noma phansi, kungakhathaliseki ukuthi yiziphi izinombolo zokugcina enanini lenombolo.

I-KRUGLVVERH

Ngalo msebenzi, ungakwazi ukuzungezisa inani lenombolo ukusuka ku-0 ukuya enombolweni ethile. Ukubukeka kwefomula: RUNDUP(inombolo, inombolo yamadijithi). Ukukhishwa kwekhodi yefomula kuyafana nalokho komsebenzi we-ROUND - inombolo yinoma yiliphi inani lenombolo elidinga ukufinyezwa, futhi esikhundleni senani lamadijithi, inani lenombolo yezinhlamvu lapho isisho esivamile sidinga khona. kuncishiswe kusethiwe.

ZUZA PHANSI

Kusetshenziswa le fomula, inani lenombolo lifinyezwa phansi - liqala ukusuka ku-zero nangaphansi. Ukubukeka komsebenzi: I-ROUNDDOWN(inombolo, inombolo yamadijithi). Ukukhishwa kwamakhodi kwale fomula kuyafana naleyo yangaphambilini.

Umsebenzi ongu-round

Enye ifomula ewusizo esetshenziselwa ukuhlanganisa amanani ezinombolo ahlukahlukene ithi ROUND. Isetshenziselwa ukuzungeza inombolo endaweni ethile yedesimali ukuze kutholwe umphumela onembile.

Imiyalo ezungezayo

Isibonelo esivame kakhulu sefomula yokusondeza amanani ezinombolo yile nkulumo elandelayo: Umsebenzi(inani lenombolo; inombolo yamadijithi). Isibonelo esizungezayo esivela kusibonelo esisebenzayo:

1. Khetha noma iyiphi iseli yamahhala enenkinobho yegundane engakwesokunxele.
2. Bhala uphawu "=".
3. Khetha eyodwa yemisebenzi - RUND, RoundUP, ROUNDDOWN. Yibhale ngokushesha ngemva kophawu olulinganayo.
4. Bhala amanani adingekayo kubakaki, cindezela inkinobho ethi "Enter". Iseli kufanele libonise umphumela.

Noma yimiphi imisebenzi ingasethwa “NgeWizadi Yomsebenzi” kuseli ethile, isho ukuthi kuseli ngokwayo noma ngomugqa wokwengeza amafomula. Lesi sakamuva siboniswa uphawu "fx". Uma ufaka ngokuzimela umsebenzi kuseli noma ulayini wamafomula, uhlelo luzobonisa uhlu lwezinketho ezingaba khona ukwenza umsebenzi womsebenzisi ube lula.

Enye indlela yokwengeza imisebenzi ukwenza izibalo ezehlukene zezibalo ngokusebenzisa ibha yamathuluzi eyinhloko. Lapha udinga ukuvula ithebhu "Amafomula", khetha inketho oyithandayo ohlwini oluvulayo. Ngemva kokuchofoza kunoma yimiphi imisebenzi ehlongozwayo, iwindi elihlukile elithi "Izimpikiswano Zomsebenzi" lizovela esikrinini, lapho udinga ukufaka inani lezinombolo emgqeni wokuqala, inani lamadijithi okuzungeza - okwesibili.

Kungenzeka ukuveza ngokuzenzakalelayo imiphumela ngokusondeza zonke izinombolo kukholomu eyodwa. Ukuze wenze lokhu, kuyadingeka ukwenza ukubala kwelinye lamaseli aphezulu kakhulu, esitokisini esibhekene nayo. Uma umphumela utholakele, udinga ukuhambisa ikhesa emaphethelweni aleli seli, ulinde ukuthi kuvele isiphambano esimnyama ekhoneni layo. Ubambe i-LMB, welula umphumela waso sonke isikhathi sekholomu. Umphumela kufanele ube ikholomu enayo yonke imiphumela edingekayo.

Kubalulekile! Kunamanye amafomula amaningana angasetshenziswa ohlelweni lokuhlanganisa amanani ezinombolo ahlukahlukene. I-ODD - ifinyeza ifike enombolweni eyinqaba yokuqala. NGISHO - Ukusondeza inombolo yokuqala elinganayo. YEHLISIWE - kusetshenziswa lo msebenzi, inani lenombolo lifinyezwa enombolweni yonke ngokulahla wonke amadijithi ngemva kwephoyinti ledesimali.

Isiphetho

Ukuhlanganisa amanani ezinombolo ku-Excel, kunamathuluzi amaningi - imisebenzi ngayinye. Ngamunye wabo wenza izibalo ngendlela ethile (ngezansi noma ngenhla 0). Ngesikhathi esifanayo, inombolo yamadijithi isethwe ngumsebenzisi ngokwakhe, ngenxa yokuthi angathola noma yimuphi umphumela wesithakazelo.