Ungahlanganisa kanjani izinombolo phezulu naphansi ku-Excel

Ngezikhathi ezithile kungase kube nesimo lapho udinga ukuzungeza izinombolo. Lokhu kungaba ukunqunywa kwentengo eseduze kakhulu esitolo, ukubalwa kwezindleko zezimpahla ngemva kokuphromotha, izinkokhelo zediphozithi nomsebenzi wokuqongelela ushintsho oluncane, nokunye.

Kunezindlela eziningana zokufeza lo msebenzi. Esokuqala ukuhlela ifomu lokubonisa inani leseli. Okwesibili ukusetshenziswa komsebenzi. Umehluko phakathi kwalezi zindlela mkhulu kakhulu. Uhlobo lwesibonisi seseli luyadingeka ezimeni lapho udinga ukubonisa inombolo encane yezinhlamvu noma uphrinte ithebula. Khona-ke kwanele ukushintsha ukubukeka kweseli. Akukushintshi lokho empeleni okuqukethwe kuyo.

Inketho yesibili ikuvumela ukuthi usebenzise inani eliyindilinga ezibalweni. Kwanele ukufaka ifomula efanele, bese le nkomba ingasetshenziswa ngezinhloso ezihlukahlukene. Kule ndaba, into eyinhloko ukungenzi amaphutha. Ngakho ake sikubhekisise kabanzi.

Ungazungeza kanjani inombolo ngokusetha ifomethi yeseli?

Asivule ithebula bese sihambisa ikhesa kuseli A1. Okulandelayo, bhala inombolo eyingxenyana engu-76,575 lapho. Ngemuva kwalokho, chofoza kwesokudla ngegundane, bese ukhetha inketho ethi "Fometha Amaseli". Kuzovela iwindi. Ingase futhi isetshenziswe ngokucindezela u-Ctrl+1 noma kuthebhu ethi Ikhaya (Ithuluzi lenombolo).

Efasiteleni elivelayo, sinentshisekelo ngefomethi yenombolo lapho sikhetha khona inombolo yezindawo zamadesimali ezidingekayo manje. Ake sicabange ukuthi bayagxambukela manje. Lapha ungasetha leli nani libe ngu-0.

Ngemva kokuqinisekisa izinguquko ezenziwe, sizoba nenani lokugcina kuseli - 77.

Konke, njengoba sibona, kwanele ukucindezela izinkinobho ezimbalwa zegundane, futhi, njengokungathi ngomlingo, inombolo eyindilinga iqala ukuboniswa. Kodwa kufanele sikhumbule ukuthi ngeke isetshenziswe ekubalweni kwezibalo. 

Ungazungeza kanjani inombolo ngendlela efanele ku-Excel

Esimweni sethu, ukugoqa kwenziwa ngendlela yokwanda. Kuya ngenombolo ekhishwayo. Uma kukhona u-5 noma ngaphezulu phambi kwenani elifiswayo, khona-ke ukuzungeza kwenziwa ngendlela yokwanda, futhi uma kuncane, kufinyezwa phansi. Konke kunjengoba kufanele kwenziwe kwizibalo, azikho izinguquko emithethweni.

Ukunemba komphumela kuncike ekutheni bangaki abalingiswa engxenyeni eyingxenyana umuntu anqume ukuyishiya. Uma inkulu, iphezulu ukunemba. Ngakho-ke, kunconywa kakhulu ukuthi uzungeze amanani kuphela lapho kunesidingo sangempela sokwenza kanjalo.. Ngezinye izikhathi ngisho nokufinyezwa okuncane kungenza ukubala kutsheke ngokuphelele. Lokhu, ngendlela, kungesinye sezizathu ezivame kakhulu zokuthi kungani ababikezeli bevame ukungalungile. Ngisho nomphumela wovemvane watholakala lapho, ngenxa yomehluko omncane phakathi kwenani eliyindilinga nelamanje, inkathi yemvula yabikezelwa.

Ungafinyeza kanjani inombolo phezulu naphansi?

Indlela efaneleke kakhulu yokuzungeza ku-Excel ukusebenzisa umsebenzi wezibalo. Ngosizo lwayo, ungathola ukuzungeza kwangempela, hhayi okubonakalayo. Inzuzo yale ndlela ukuthi umuntu angakwazi ukuzinqumela ukuthi uzojikela ngakuphi. Kodwa kuze kube yilapho sembula wonke amakhadi, sigcina ubuqili. Kakhudlwana nje, futhi uzokwazi ukuthi yiziphi izenzo okudingeka uzithathe ukuze ufinyelele lo mgomo.

Ufinyeza kanjani inombolo ephelele

Njengoba kubonisiwe esibonelweni esandulele, kwanele ukususa izinombolo engxenyeni yengxenye yefomula, njengoba inombolo iba inombolo ephelele. Kusebenza kanjalo ukugoqa! Kodwa ngosizo lwefomula, ungathola inamba yangempela, futhi indlela echazwe ngenhla iyindlela ebonakalayo. Kodwa i-logic ayishintshi kuye ngokuthi umphumela wangempela noma obonakalayo uzovezwa yini. Usadinga ukubeka izinhlamvu ezinguziro.

Kungenzeka futhi ukusebenzisa imisebenzi I-KRUGLVVERH и ZUZA PHANSIukugcina inombolo eyindilinga kuphela. Ngokunjalo, imizuliswano yokuqala iya phezulu, futhi imizuliswano yesibili ibheke kolunye uhlangothi. Endabeni yamanani angalungile, okuphambene kuyiqiniso, ngoba ukuzungeza kwenziwa i-modulo 

Kungani i-Excel ihlanganisa izinombolo ezinkulu?

Cishe kunoma yisiphi isibali noma uhlelo, uma ufaka izinombolo ezinkulu kakhulu, zifinyezwa kufomu E + njalonjalo. I-Excel nayo injalo. Kungani lokhu kwenzeka?

Uma inombolo iqukethe amadijithi angaphezu kuka-11, khona-ke iguqulwa ngokuzenzakalelayo ibe ngu-1,111E+11. Lokhu kumelwa kwenombolo kubizwa ngokuthi yi-exponential. Kunzima kakhulu ukwenza indlela yokumela enjalo mathupha. Ukuze wenze lokhu, udinga ukubala i-logarithm yenombolo bese wenza imisebenzi embalwa eyengeziwe.

Uma singafuni ukuthi i-Excel ihlanganise izinombolo ezinkulu, sidinga ukwandulela inani elihambisanayo nge-'. Okokuqala udinga ukusetha ifomethi yombhalo. Kodwa ngeke kusenzeka ukwenza imisebenzi yezibalo ngaphandle kokusebenzisa amafomula akhethekile. 

Kuyamukeleka futhi ukufaka amanani njengenombolo enezikhala. I-Excel izoguqula ngokuzenzakalela iseli libe yifomethi yombhalo. Akunakwenzeka ukusebenzisa ngokuqondile ukuze uhlelo lwesipredishithi lungakwenzi lokhu. Kuphela ngokufaka i-apostrophe. 

Ungazungeza kanjani umsebenzi we-Excel?

Futhi manje ake siye ngqo ukuzilolonga. Yini okufanele yenziwe ukuzungezisa izinombolo kusetshenziswa umsebenzi? Kunomsebenzi okhethekile walokhu. I-ROUNDWOOD. Ingabizwa ngezindlela ezahlukene: ngeribhoni ezinguqulweni ze-Excel 2007 nezintsha.

Indlela yesibili ukubhala ngesandla. Ithuthuke kakhulu ngoba udinga ukwazi i-syntax okungenani.

Indlela elula yalowo oqalayo ukusebenzisa iwizadi yokusebenza. Ukuze wenze lokhu, udinga ukuthola inkinobho eduze komugqa wokufaka wefomula, lapho kubhalwa khona inhlanganisela yezinhlamvu ezincane fx. Ungathola lo msebenzi esigabeni esithi “Izibalo”, futhi ngemva kokusikhetha, uzocelwa ukuba ufake izimpikiswano. Ngayinye yazo isayiniwe, ngakho kulula ukuyiqonda.

I-Round Function Syntax

Uma kusetshenziswa okokufaka okwenziwa ngesandla, kuzomele uqonde indlela yokubhala ifomula ngendlela efanele. Uhlelo okufakwa ngalo amanani lubizwa ngokuthi i-syntax. Noma yimuphi umsebenzi une-syntax evamile yendawo yonke. Okokuqala, kubhalwe uphawu olulinganayo, bese kuba igama lomsebenzi, bese kuba izimpikiswano, ezibhalwe kubakaki, futhi zihlukaniswe ngekhoma. Inani lama-agumenti lingase lihluke kumsebenzi nomsebenzi. Kwezinye zazo azikho nhlobo, futhi eziningana zazo kukhona okungenani 5, okungenani ngaphezulu. 

Endabeni yomsebenzi we-ROUND, kukhona okubili. Ake sizibheke ngokuningiliziwe.

RUND ama-agumenti omsebenzi

Ngakho umsebenzi unezimpikiswano ezimbili:

1. Inombolo. Lesi yisithenjwa seseli. Kungenjalo, ungakwazi ukufaka inani olifunayo kule mpikiswano mathupha.
2. Inani lamadijithi ozofinyeza kuwo.
   

   

Ukuze ufinyeze inombolo ephelele (okungukuthi, leyo engenazo izindawo zedesimali), mane ubhale uphawu lokususa phambi kwenombolo kupharamitha yesibili. Ukuze ufinyelele emashumini, udinga ukubhala -1, emakhulwini - -2, bese ulandela le logic phambili. Uma imojula yale nombolo inkulu, amadijithi amaningi azofinyezwa. 

Izisekelo zomsebenzi I-ROUNDWOOD

Ake sibheke ukuthi lo msebenzi ungasetshenziswa kanjani, kusetshenziswa isibonelo sokusondeza ezinkulungwaneni.

Ake ucabange sinetafula elinjalo. Sibhale ifomula yokusondeza kuseli yesibili, futhi sibona umphumela kulesi sithombe-skrini.

Kungenzeka ukuzungeza hhayi inombolo kuphela, kodwa nanoma yiliphi inani. Esibonelweni, kubonakala kanje. Ake sithi sinezinsika ezintathu. Kweyokuqala, intengo yezimpahla irekhodwa, okwesibili - ukuthi yathengwa malini. Kodwa okwesithathu, ngokulandelana, izindleko zokugcina zikhonjisiwe. 

Cabanga ukuthi umsebenzi wethu ukukhombisa inani lama-ruble, futhi ungayinaki i-penny. Bese uthola ithebula elilandelayo.

Ngobuningi

I-Excel yenza kube nokwenzeka ukuzungeza izinombolo hhayi kweseduze, kodwa kweyokuphindaphinda kweyodwa. Kukhona umsebenzi okhethekile walokhu obizwa ngokuthi ROUND. Ngosizo lwayo, ungafinyelela ukunemba kokujikeleza okudingekayo. 

Kunezimpikiswano ezimbili eziyinhloko. Esokuqala inombolo edinga ukufinyezwa. Eyesibili inombolo okufanele ibe ukuphindaphinda kwaleyo enikiwe. Zombili izimpikiswano zingadluliswa ngokwenza noma ngeseli. 

Ngenombolo yezinhlamvu

Zonke izibonelo ezichazwe ngenhla ziyizimo ezikhethekile zokufinyezwa ngenani lezinhlamvu. Kwanele ukufaka inombolo edingekayo yezinhlamvu ezizoshiywa ku-agumenti ehambisanayo yomsebenzi. Empeleni, yilokho kuphela. 

Ukusondeza ku-Excel usebenzisa umsebenzi we-ROUNUP

Umsebenzisi angakwazi ngokuzimela ukusetha isiqondiso for rounding. Ukusebenzisa umsebenzi I-KRUGLVVERH ungakhipha amadijithi engeziwe noma uzungeleze inombolo yonke ufike kuleyo evelayo ephakeme.

Isibonelo sokusebenzisa le fomula singabonakala kulesi sithombe-skrini.

Umehluko omkhulu phakathi kwalo msebenzi kanye I-ROUNDWOOD ukuthi umsebenzi uhlala ujikeleza. Uma kukhona noma yimaphi amadijithi enani, ukufinyezwa kuyenziwa enombolweni ethile yazo.

I-Syntax Yomsebenzi we-ROUNDUP

Lo msebenzi uthatha izimpikiswano ezimbili. Ngokuvamile, umsebenzi ubukeka kanje.

=ROUNDLVVERH(76,9)

Manje ake sihlolisise izimpikiswano zakhe.

Izimpikiswano Zomsebenzi RoundUP

I-syntax yalo msebenzi, njengoba sibona, ilula kakhulu. Izimpikiswano zimi kanje:

1. Inombolo. Lena yinoma iyiphi inombolo edinga ukufinyezwa.

2. Inombolo yamadijithi. Inombolo yamadijithi azosala ngemva kokwenziwa kokufinyezwa ifakwe lapha.

Ngakho, ku-syntax, le fomula ayihlukile I-ROUNDWOOD. Imodi yenombolo inquma ukuthi yiziphi izinombolo ezizoncishiswa. Uma i-agumenti yesibili ithi phozithivu, khona-ke ukufinyezwa kwenziwa kwesokudla sephoyinti ledesimali. Uma inegethivu, bese kwesokunxele. 

Ukusondeza phansi ku-Excel usebenzisa umsebenzi ZUZA PHANSI

Lo msebenzi usebenza ngendlela efanayo neyangaphambilini. Inezimpikiswano ezifanayo kanye ne-syntax, kanye namaphethini okusetshenziswa afanayo. Umehluko kuphela ukuthi ukugoqa kwenziwa ngendlela ebheke phansi (kusuka enombolweni enkulu kuye kwencane, ngamanye amazwi). Ngakho igama.

Yonke imigomo yokusetshenziswa nayo iyafana. Ngakho-ke, uma i-agumenti yesibili (sizobanika kamuva) ilingana noziro, inombolo ifinyezwa ibe inombolo ephelele. Uma ingaphansi kuka-0, inani lamadijithi ngaphambi kwephoyinti ledesimali liyancishiswa. Uma likhulu kunoziro, emva kwalokho-ke. Ngale ndlela, ungakwazi ukususa inani elithile lamafrakshini amadesimali.

I-RoundDOWN Function Syntax

Ngakho-ke, i-syntax ifana ngokuphelele nesibonelo sangaphambilini. Ngokuvumelana nalokho, akuhlukile ikakhulukazi. Kodwa uma kunesifiso esinjalo, i-Excel yenza kube lula ukusebenzisa lo msebenzi ngokuzimela.

Okokuqala udinga ukuya kudokhumenti oyifunayo, uvule ishidi elifanele bese uqala ukubhala uphawu olulinganayo emgqeni wokufaka wefomula. Ngemva kwalokho, kufanele ucacise ngokuqondile igama lefomula I-ROUNDDOWN, bese ufaka izimpikiswano ezimbili.

Ngokuvamile, ifomula ibukeka kanje.

=RoundString(3,2, 0)

Manje ake sibhekisise ukuthi yiziphi izimpikiswano lo msebenzi onazo.

Izimpikiswano zomsebenzi ZUZA PHANSI

Kulokhu, izimpikiswano zifana ncamashi nenguqulo yangaphambilini. Okokuqala udinga ukucacisa izinombolo ezidinga ukuzungezwa (inombolo eyodwa noma uhla lonke), ngemva kwalokho, nge-semicolon, cacisa inani lamadijithi azoncishiswa. Yonke eminye imithetho ifana ngokuphelele.

Ngakho-ke, ukusondeza ku-Excel kuyisici esilula kakhulu kodwa esiwusizo esivumela umuntu ukuba enze izibalo noma ukubona kalula. Into esemqoka ukuqonda ngokucacile ukuthi iyiphi indlela futhi yiziphi izimo ezithile okufanele zisetshenziswe. Uma sidinga kuphela ukubonisa idatha ngokubonakalayo (ukuphrinta kungenye yezinto ezingase zisetshenziswe), ngakho-ke sidinga ukusebenzisa ifomethi yeseli. 

Uma umuntu edinga ukwenza imisebenzi yezibalo egcwele, khona-ke ukusebenzisa umsebenzi noma ifomula ukuphela kwendlela engenzeka. Yiqiniso, izimo ezinjalo azivamile. Ngokuvamile abantu, ngokuphambene nalokho, bazungeza ingqondo.