Yadda ake zagaye lamba a Excel. Tsarin lamba ta cikin menu na mahallin, saita daidaiton da ake buƙata, saitunan nuni

Faɗin daftarin aiki na Excel yana da fa'idan ayyuka waɗanda ke ba ku damar yin magudi iri-iri tare da bayanan lambobi. Sau da yawa yakan faru cewa lokacin aiwatar da ayyuka daban-daban, an karkatar da ƙimar juzu'i. Wannan sifa ce mai matukar amfani, tunda yawancin ayyukan da ke cikin shirin baya buƙatar ingantaccen sakamako. Duk da haka, akwai irin wannan lissafin inda ya zama dole don adana daidaiton sakamakon, ba tare da yin amfani da zagaye ba. Akwai hanyoyi da yawa don aiki tare da lambobi masu zagaye. Bari mu dubi komai dalla-dalla.

Yadda ake adana lambobi a cikin Excel da nunawa akan allo

Tsarin maƙunsar bayanai yana aiki akan nau'ikan bayanan ƙididdiga guda biyu: m da madaidaici. Mutumin da ke aiki a cikin editan rubutu zai iya zaɓar hanyar don nuna ƙimar ƙima, amma a cikin Excel kanta, bayanan suna cikin ainihin tsari - har zuwa haruffa goma sha biyar bayan ma'anar ƙima. A wasu kalmomi, idan nunin ya nuna bayanai har zuwa wurare na ƙima biyu, to, maƙunsar bayanai za ta koma zuwa mafi daidaito rikodin a cikin ƙwaƙwalwar ajiya yayin lissafin.

Kuna iya tsara nunin bayanin lamba akan nunin. Ana aiwatar da tsarin zagaye bisa ga ka'idoji masu zuwa: alamomi daga sifili zuwa hudu sun haɗa da ƙasa, kuma daga biyar zuwa tara - zuwa mafi girma.

Fasalolin zagaye lambobin Excel

Bari mu bincika dalla-dalla dalla-dalla hanyoyi da yawa don zagaya bayanan lambobi.

Zagayawa tare da Maɓallan Ribbon

Yi la'akari da hanyar daidaitawa mai sauƙi. Cikakken umarnin yayi kama da haka:

1. Muna zaɓar tantanin halitta ko kewayon sel.
2. Mun matsa zuwa sashin "Gida" kuma a cikin "Lambar" umarnin toshe, danna LMB akan "Ƙara zurfin zurfin" ko "Ƙara zurfin bit". Yana da kyau a lura cewa kawai zaɓaɓɓun bayanan lambobi kawai za a tattara su, amma har zuwa lambobi goma sha biyar na lambar ana amfani da su don ƙididdigewa.
3. Haɓaka haruffa da ɗaya bayan waƙafi yana faruwa bayan danna maɓallin "Ƙara zurfin zurfafa".

4. Ana yin raguwar haruffa da ɗaya bayan danna maɓallin "Rage zurfin zurfin".

Zagayawa Ta hanyar Tsarin Tantanin halitta

Yin amfani da akwatin da ake kira "Format Cell", kuma yana yiwuwa a aiwatar da gyare-gyaren zagaye. Cikakken umarnin yayi kama da haka:

1. Muna zaɓar tantanin halitta ko kewayo.
2. Danna RMB akan yankin da aka zaɓa. An buɗe menu na mahallin musamman. Anan zamu sami wani abu mai suna "Format Cells..." kuma danna LMB.

3. Tagar Tsara Kwayoyin Yana bayyana. Je zuwa sashin "Lambar". Muna kula da ginshiƙin "Tsarin lambobi:" kuma muna saita mai nuna alama "Lambobi". Idan ka zaɓi wani tsari na daban, shirin ba zai iya aiwatar da lambobi masu zagaye ba.. A tsakiyar taga kusa da "Lambar wuraren ƙima:" mun saita adadin haruffa waɗanda muke shirin gani yayin aikin.

4. A ƙarshe, danna maɓallin "Ok" don tabbatar da duk canje-canjen da aka yi.

Saita daidaiton lissafi

A cikin hanyoyin da aka bayyana a sama, sigogin da aka saita suna da tasiri ne kawai akan fitar da bayanan ƙididdiga na waje, kuma lokacin yin lissafin, an yi amfani da ƙarin ingantattun ƙimar (har zuwa halaye na goma sha biyar). Bari mu yi magana dalla-dalla game da yadda ake gyara daidaiton lissafin. Cikakken umarnin yayi kama da haka:

1. Je zuwa sashin "File", sannan a gefen hagu na sabuwar taga za mu sami wani abu mai suna "Parameters" kuma danna shi tare da LMB.

2. Akwatin da ake kira "Excel Options" yana bayyana akan nunin. Mun matsa zuwa "Advanced". Mun sami shingen umarni "Lokacin da ake sake lissafin wannan littafin." Yana da kyau a lura cewa canje-canjen da aka yi za su shafi dukan littafin. Sanya alamar bincike kusa da rubutun "Saita daidaito kamar akan allo." A ƙarshe, danna maɓallin "Ok" don tabbatar da duk canje-canjen da aka yi.

3. Shirya! Yanzu, lokacin da ake ƙididdige bayanai, za a yi la'akari da ƙimar fitarwa na bayanan lambobi akan nunin, kuma ba wanda aka adana a cikin ma'aunin ma'adanin ma'auni ba. Ana yin saita ƙimar ƙididdigewa da aka nuna ta kowace hanya guda 2 da aka kwatanta a sama.

Aikace-aikacen ayyuka

Hankali! Idan mai amfani yana so ya gyara zagaye yayin ƙididdigewa dangane da ɗayan sel guda ɗaya ko da yawa, amma baya shirin rage daidaiton ƙididdiga a cikin littafin aikin gabaɗaya, to yakamata yayi amfani da damar ma'aikacin ROUND.

Wannan aikin yana da amfani da yawa, gami da haɗe tare da wasu masu aiki. A cikin manyan masu aiki, ana yin zagaye:

• "ROUNDOWN" - zuwa mafi kusa lamba ƙasa a modules;
• "ROUNDUP" - har zuwa mafi kusa darajar sama a cikin modulo;
• "OKRVUP" - tare da ƙayyadaddun daidaito sama da modulo;
• "OTBR" - har zuwa lokacin da lambar ta zama nau'in lamba;
• "ZAGE" - har zuwa ƙayyadadden adadin haruffa na goma daidai da ka'idojin zagaye da aka karɓa;
• "OKRVNIZ" - tare da ƙayyadaddun daidaito a ƙasa da modulo;
• "KODA" - zuwa mafi kusa ko darajar;
• "OKRUGLT" - tare da ƙayyadaddun daidaito;
• "ODD" - zuwa mafi kusa m darajar.

Ma'aikatan ROUNDDOWN, ROUND, da ROUNDUP suna da nau'i na gaba ɗaya: =Sunan mai aiki (lambar;lambar_lambobi). A ce mai amfani yana so ya yi tsarin zagaye don ƙimar 2,56896 zuwa wurare 3 na decimal, to yana buƙatar shigar da "=ZAGAYA (2,56896;3)”. A ƙarshe, zai karɓi:

Masu aiki "ROUNDDOWN", "ROUND", da "ROUNDUP" suna da nau'i na gaba ɗaya: =Sunan mai aiki (lamba, daidaito). Idan mai amfani yana so ya zagaye ƙimar 11 zuwa mafi kusa da biyu, to yana buƙatar shigar "= ZAGAYA (11;2)". A ƙarshe, zai karɓi:

Masu aiki "ODD", "SELECT", da "VEN" suna da nau'i na gaba ɗaya:  =Sunan mai aiki (lamba). Misali, lokacin zagayawa darajar 17 zuwa mafi kusa ko ƙimar, yana buƙatar shigar "= ALHAMIS (17)". A ƙarshe, zai karɓi:

Ya kamata a lura! Ana iya shigar da mai aiki a cikin layin ayyuka ko a cikin tantanin halitta kanta. Kafin rubuta aiki a cikin tantanin halitta, dole ne a zaɓi shi a gaba tare da taimakon LMB.

Faɗin maƙunsar yana da wata hanyar shigar da afareta wanda ke ba ka damar aiwatar da tsarin kewaya bayanan lambobi. Yana da kyau lokacin da kake da tebur na lambobi waɗanda ke buƙatar juya su zuwa ƙimar ƙima a cikin wani shafi. Cikakken umarni yayi kama da haka:

1. Mun matsa zuwa sashin "Formulas". Anan zamu sami kashi "Math" kuma danna shi tare da LMB. An buɗe wani dogon jeri, inda muka zaɓi ma'aikaci mai suna "ROUND".

2. Akwatin maganganu da ake kira "Hujjar Aiki" ya bayyana akan nunin. Za a iya cika layin "Lambar" tare da bayanai da kanku ta hanyar shigar da hannu. Wani zaɓi wanda zai baka damar zagaye duk bayanai kai tsaye shine danna LMB akan alamar da ke hannun dama na filin don rubuta hujja.

3. Bayan danna wannan alamar, taga "Ayyukan Hujja" ya rushe. Mun danna LMB a saman saman filin ginshiƙi, bayanin da muke shirin zagaye. Alamar ta bayyana a cikin akwatin muhawara. Mun danna LMB akan gunkin da ke hannun dama na darajar da ta bayyana.

4. Allon ya sake nuna taga mai suna "Ayyukan Arguments". A cikin layin "Lambobin lambobi" muna motsawa a cikin zurfin zurfin abin da ya wajaba don rage raguwa. A ƙarshe, danna maɓallin "Ok" don tabbatar da duk canje-canjen da aka yi.

5. An tattara ƙimar lamba. Yanzu muna buƙatar aiwatar da tsarin zagaye don duk sauran sel a cikin wannan shafi. Don yin wannan, matsar da maɓallin linzamin kwamfuta zuwa kusurwar dama na filin tare da sakamakon da aka nuna, sannan, ta hanyar riƙe da LMB, shimfiɗa dabarar zuwa ƙarshen tebur.

6. Shirya! Mun aiwatar da tsarin zagaye ga duk sel a cikin wannan shafi.

Yadda ake tattarawa da saukarwa a cikin Excel

Bari mu kalli mai aikin ROUNDUP. An cika hujja ta 1 kamar haka: an shigar da adireshin tantanin halitta tare da bayanan lambobi. Cika hujja ta 2 tana da ƙa'idodi masu zuwa: shigar da ƙimar "0" yana nufin kewaya juzu'in juzu'i zuwa sashin lamba, shigar da ƙimar "1" yana nufin cewa bayan aiwatar da tsarin zagaye za a sami hali ɗaya bayan ma'aunin ƙima. , da sauransu. Shigar da ƙimar mai zuwa a cikin layi don shigar da ƙididdiga: = ZAGAYA (A1). A ƙarshe muna samun:

Yanzu bari mu kalli misalin amfani da ROUNDDOWN afaretan. Shigar da ƙima mai zuwa a cikin layi don shigar da ƙididdiga: = ROUNDSAR(A1).A ƙarshe muna samun:

Ya kamata a lura cewa masu aiki "ROUNDDOWN" da "ROUNDUP" ana kuma amfani da su don aiwatar da hanyar da za a zagaya bambancin, ninkawa, da dai sauransu.

Misali na amfani:

Yadda za a zagaya zuwa duka lamba a Excel?

Mai aiki na "SELECT" yana ba ku damar aiwatar da zagayawa zuwa lamba kuma ku watsar da haruffa bayan maki goma. Misali, la'akari da wannan hoton:

Aiki na musamman da ake kira "INT" yana ba ku damar dawo da ƙimar lamba. Akwai hujja ɗaya kawai - "Lambar". Kuna iya shigar da ko dai bayanan lamba ko haɗin gwiwar salula. Misali:

Babban rashin lahani na mai aiki shine cewa ana aiwatar da zagaye kawai ƙasa.

Don kewaya bayanan lambobi zuwa ƙimar lamba, wajibi ne a yi amfani da ma'aikatan da aka yi la'akari da su a baya "ROUNDDOWN", "KODA", "ROUNDUP" da "ODD". Misalai biyu na amfani da waɗannan masu aiki don aiwatar da zagaye zuwa nau'in lamba:

Me yasa Excel ke zagaye manyan lambobi?

Idan rukunin shirin ya ƙunshi ƙima mai girma, misali 73753956389257687, to zai ɗauki nau'i mai zuwa: 7,37539E+16. Wannan saboda filin yana da ra'ayi "Gaba ɗaya". Domin kawar da irin wannan nau'in fitarwa na dogayen dabi'u, kuna buƙatar gyara tsarin filin kuma canza nau'in zuwa Lambobi. Haɗin maɓallin “CTRL + SHIFT + 1” zai ba ku damar aiwatar da tsarin gyarawa. Bayan yin saitunan, lambar za ta ɗauki hanyar nuni daidai.

Kammalawa

Daga labarin, mun gano cewa a cikin Excel akwai manyan hanyoyi guda 2 don zagaye bayanan bayanan da ake iya gani: ta amfani da maballin a kan kayan aiki, da kuma daidaita saitunan tsarin salula. Bugu da ƙari, kuna iya aiwatar da gyara zagaye na bayanan ƙididdiga. Hakanan akwai zaɓuɓɓuka da yawa don wannan: daidaita sigogin takaddun, da kuma amfani da masu sarrafa lissafi. Kowane mai amfani zai iya zaɓar wa kansa mafi kyawun hanyar da ta dace da takamaiman manufofinsa da manufofinsa.