Yana ɗaya daga cikin ayyuka mafi inganci kuma wanda za mu yi amfani da shi akai-akai lokacin da muke aiki tare da maƙunsar bayanai: Zagaye a cikin Excel. Wannan aiki yana da amfani sosai lokacin da muke aiki tare da adadi masu yawa. Juyawa kashewa zai iya sauƙaƙa lissafinmu na yau da kullun.
El zagaye Sanannen lissafi ne wanda ya ƙunshi canza lamba ko lambobi har sai ya kai wata ƙima. Lambar "zagaye", ba tare da ƙima ba. Akwai hanyoyi da yawa don zagaye, sama ko ƙasa, zuwa adadin raka'a, goma, ɗaruruwa, da sauransu. A kowane hali, manufar koyaushe ɗaya ce: don rage lamba da sauƙaƙa shi ta yadda za a iya amfani da shi cikin sauƙi.
Gaskiyar ita ce, a cikin rayuwarmu ta yau da kullum muna tarawa, ko dai a sane ko a cikin rashin sani. Misali, idan farashin tufa ya kai Yuro 17,89, sai mu ce ya kai mu Yuro 18. Sauƙaƙe don sadarwa mafi kyau. Hakanan yana faruwa tare da ƙimar lambobi waɗanda muke amfani da su don aiwatar da ayyukan lissafi ko na kuɗi, duka a cikin lissafin cikin gida da kuma a fagen ƙwararru.
A zagaye na lambobi masu ɗauke da ƙima Shi ne shari'ar da aka saba yi, kodayake kuma muna iya amfani da shi don zagaya adadi zuwa kowace naúrar da muke so. Gabaɗaya, akwai hanyoyi guda biyu don gudanar da shi. Mun misalta shi da misali: zagaye lamba 55, 45 kawar da decimals.
- Shafin: 55,45-56
- Shafin: 55,45 -> 55
A taƙaice, muna iya cewa zagayawa lamba yana ba mu damar sami hoto mafi sauƙi da haske na adadin da muke sarrafa, yayin yana sauƙaƙa lissafi sosai. A daya bangaren kuma, ta hanyar zagaye muna rasa daidaito. Ba a ba da shawarar lokacin da muke buƙatar yin ƙididdiga daidai ba. A takaice, saukakawa na zagaye ko a'a zai dogara ne akan amfani da za mu ba da adadi. Ba a ba da shawarar ba, misali, idan muna ƙididdige harajin da za a biya.
Round aiki a cikin Excel
zagayawa Excel akwai takamaiman aiki wanda sunansa shine: ROUND. Na gaba za mu yi bayanin abin da za mu yi don amfani da shi daidai.
Abu na farko da ya kamata a sani shi ne, don farawa, ya zama dole a fayyace gardama guda biyu: lambar da muke da ita da wuraren goma da muke son samun wannan lamba. Za mu sami aikin a cikin Lissafi da nau'in trigonometric. Maganar da za a yi amfani da ita ita ce mai zuwa
= ZAGAYA (lamba; wurare masu lamba)
- Takaddama "lamba" shine ainihin lambar da muke son amfani da ita.
- Takaddama "lambobin ƙididdiga" Ana amfani da shi don ƙididdige adadin wuraren ƙima zuwa waɗanda muke son zagaye ainihin lambar. *
(*) A cikin Excel, ko da yaushe ana yin lambobi marasa kyau zuwa hagu na maƙasudin ƙima, yayin da sifili ke zagaye zuwa mafi kusa da lamba.
ROUND a cikin Excel, mataki-mataki
Na gaba mun bayyana yadda ake zagaye a cikin Excel mataki-mataki, kwatanta tsari tare da misali, wanda koyaushe yana da sauƙin fahimtar komai.
Bari mu yi tunanin cewa an tattara apples 5.000 a gona kuma ya zama dole a loda su cikin akwatuna waɗanda iyakar ƙarfin su shine guda 30 na 'ya'yan itace kowane. Akwatuna nawa za mu buƙaci? Idan muka yi sauƙi mai sauƙi (5.000 an raba ta 30) yana ba mu sakamako tare da ƙididdiga: akwatuna 166,666.
Kamar yadda yake a hankali, a aikace za mu sami akwatuna 166 kawai kuma za mu sami ragowar apples kaɗan, ko kwalaye 167 kuma ɗaya daga cikinsu ba zai cika gaba ɗaya ba. Taɓa zagaye. Ga yadda za mu yi:
- Mun zaɓi tantanin halitta wanda muke son aiwatar da aikin kuma mu rubuta = ROUND.
- Sa'an nan kuma, a tsakanin baka, muna nuna tantanin halitta da kuma, rabuwa da semicolon, adadin wuraren da muke so, wanda a wannan yanayin ba shi da kome, tun da muna neman lamba*. Misali: = ZAGAYA (A1).
Sakamakon da za mu samu a cikin wannan takamaiman misali shi ne cewa za mu buƙaci akwatuna 167 don tattara duk apples.
(*) Idan muna buƙatar zagaye zuwa goma na farko, adadi da za mu shigar shine 1; zuwa zagaye na biyu na decimal, 2. Da sauransu. A gefe guda, don zagaye zuwa mafi kusa na 10, ƙimar da za a shigar za ta kasance -1, zuwa yawan 100, -2; zuwa yawan 1.000 -3, da dai sauransu.
Takamaiman ayyuka don zagaye a cikin Excel
Bayan ainihin aikin ROUNDING, hanyar amfani da shi wanda muka yi bayani a cikin sashin da ya gabata, a cikin Excel akwai sauran su. bambance-bambancen karatu don ƙididdige zagaye ta hanya ta musamman ko sharadi. Wannan shine jerin zaɓuɓɓuka:
- ROUNDUP: Yana zagaye lambar sama (misali, daga 9,5 zuwa 10).
- ROUND.DOWN: Yana juya lambar ƙasa (misali, daga 9,5 zuwa 9).
- INTEGER: Yana zagayawa zuwa gabakiyan lamba mafi kusa.
- ZAGAYA MULT: Yana zagaya lamba zuwa ƙayyadaddun yawa.
- MULTIPLE.UPER: Yana aiki tare, har zuwa mafi kusa.
- MULTIPLE.LOWER: Yana amfani da zagaye ƙasa zuwa mafi kusa.
- TRUNCATE: Kawai yana cire ɓangaren decimal na lamba.
- ROUND.EVEN: Wannan aikin yana zagaye lamba har zuwa madaidaicin lamba na gaba.
- ROUND.ODD: Yana yin abu iri ɗaya, amma har zuwa lamba mara kyau na gaba.