Yadda ake zagaye sakamako a cikin Excel - dabaru

Ɗaya daga cikin shahararrun hanyoyin lissafi waɗanda mutane sukan yi amfani da su yayin aiki tare da maƙunsar bayanai na Excel shine zagaye lambobi. Wasu masu farawa suna ƙoƙarin yin amfani da tsarin lamba, amma ba a tsara shi don nuna ainihin lambobi a cikin sel ba, wanda ke haifar da kurakurai. Don samun sakamakon da ake so bayan zagaye, dole ne ku yi amfani da ayyuka na musamman waɗanda aka tsara don wannan aikin lissafi. Kuna buƙatar sanin kowane ɗayansu dalla-dalla.

ROUND aiki

Mafi sauƙaƙan aikin da zaku iya zagaye ƙimar lamba da adadin lambobi da ake buƙata shine ROUND. Misali mafi sauƙaƙa shine kewaya ƙididdiga daga wurare goma sha biyu zuwa ɗaya.

Yana da mahimmanci a tuna cewa wannan aikin yana zagaye ne kawai daga sifili.

Siffar dabarar ROUND: ZAGAYA (lamba, adadin lambobi). Fadada hujja:

1. Adadin lambobi – anan dole ne ka ƙididdige adadin lambobi waɗanda za a haɗa darajar lambobi zuwa gare su.
2. Lamba - wannan wuri na iya zama ƙimar lambobi, juzu'in ƙima, wanda za a zagaye.

Adadin lambobi na iya zama:

• korau - a wannan yanayin, kawai ɓangaren lamba na ƙimar ƙididdiga (wanda ke hagu na ma'aunin ƙima) yana zagaye;
• daidai da sifili - duk lambobi suna zagaye zuwa ɓangaren lamba;
• tabbatacce - a wannan yanayin, ɓangaren juzu'i ne kawai, wanda ke hannun dama na maki goma, an zagaye.

Hanyoyin saitawa:

1. Domin samun lamba ta zagaye zuwa goma a sakamakon haka, kuna buƙatar buɗe taga tare da saita gardamar aiki, shigar da ƙimar "1" a cikin layin "yawan lambobi".
2. Don zagaye ƙimar lamba zuwa ɗari, kuna buƙatar shigar da ƙimar "2" a cikin taga saitunan mahallin aiki.
3. Don samun ƙima mai ƙima zuwa dubu mafi kusa, a cikin taga don saita muhawara a cikin layin "yawan lambobi" dole ne ku shigar da lamba "3".

ROUNDUP da ROUNDDOWN ayyuka

Ƙarin dabaru guda biyu waɗanda aka ƙirƙira don zagayawa ƙimar lambobi a cikin Excel sune ROUNDUP da ROUNDOWN. Tare da taimakonsu, zaku iya zagaye ƙananan lambobi sama ko ƙasa, ba tare da la'akari da waɗanne lambobi na ƙarshe suke cikin ƙimar lamba ba.

KRUGLVVERH

Tare da wannan aikin, zaku iya zagaye ƙimar lamba daga 0 zuwa lambar da aka bayar. Siffar dabarar: ROUNDUP(lamba, adadin lambobi). Ƙaddamar da dabarar daidai yake da na aikin ROUND - lambar ita ce kowace ƙima ta lambobi da ake buƙatar tadawa, kuma a maimakon adadin lambobi, adadin adadin haruffan da ake buƙatar magana gaba ɗaya. a rage an saita.

ZAGAYA KASA

Yin amfani da wannan dabara, ƙimar lambobi an ƙirƙira ƙasa - farawa daga sifili da ƙasa. Siffar aiki: ROUNDOWN(lamba, adadin lambobi). Decoding na wannan dabara daidai yake da na baya.

ROUND aiki

Wata dabara mai amfani da ake amfani da ita don zagayawa nau'ikan ƙididdiga daban-daban ita ce ROUND. Ana amfani da shi don zagaye lamba zuwa wani wuri na ƙima don samun ingantaccen sakamako.

umarnin zagaye

Misalin gama gari na dabara don zagaya ƙimatin lambobi shine magana mai zuwa: Aiki (darajar lamba; adadin lambobi). Misali na zagaye daga misali mai amfani:

1. Zaɓi kowane tantanin halitta kyauta tare da maɓallin linzamin kwamfuta na hagu.
2. Rubuta alamar "=".
3. Zaɓi ɗayan ayyukan - ZAGAYA, ZAGAYA, ZAGAYA. Rubuta shi daidai bayan alamar daidai.
4. Rubuta ƙimar da ake buƙata a maƙallan, danna maɓallin "Shigar". Ya kamata tantanin halitta ya nuna sakamakon.

Ana iya saita kowane ayyuka ta hanyar "Mayen Aiki" zuwa takamaiman tantanin halitta, rubuta su a cikin tantanin halitta kanta ko ta layin don ƙara ƙira. Ana nuna ƙarshen ta alamar "fx". Lokacin da ka shigar da aiki da kansa cikin tantanin halitta ko layi don ƙira, shirin zai nuna jerin yuwuwar zaɓuɓɓuka don sauƙaƙe aikin mai amfani.

Wata hanyar da za a ƙara ayyuka don yin lissafin lissafin lissafi daban-daban ita ce ta babban kayan aiki. Anan kuna buƙatar buɗe shafin "Formulas", zaɓi zaɓi na sha'awa daga jerin da ke buɗewa. Bayan danna kan kowane ɗayan ayyukan da aka tsara, taga daban "Ayyukan Hujja" zai bayyana akan allon, wanda kuna buƙatar shigar da ƙimar lambobi a cikin layin farko, adadin lambobi don zagaye - a cikin na biyu.

Yana yiwuwa a nuna sakamakon ta atomatik ta hanyar zagaye duk lambobi daga shafi ɗaya. Don yin wannan, dole ne a yi lissafin ɗaya daga cikin mafi girman sel, a cikin tantanin halitta da ke gabansa. Lokacin da aka sami sakamakon, kuna buƙatar matsar da siginar zuwa gefen wannan tantanin halitta, jira baƙar giciye ya bayyana a kusurwar sa. Rike LMB, shimfiɗa sakamakon har tsawon lokacin ginshiƙi. Sakamakon yakamata ya zama ginshiƙi tare da duk sakamakon da ake buƙata.

Muhimmin! Akwai wasu ƙididdiga da yawa waɗanda za a iya amfani da su wajen aiwatar da zagaya ƙima daban-daban. ODD - yana zagaye har zuwa lamba mara kyau ta farko. KODA – Yana zagayawa har zuwa lamba ta farko. RAGE – ta yin amfani da wannan aikin, ana zagayawa ƙimar lamba zuwa gabakiyan lamba ta hanyar watsar da duk lambobi bayan ma'aunin ƙima.

Kammalawa

Don zagaye ƙimar lambobi a cikin Excel, akwai kayan aiki da yawa - ayyuka na mutum. Kowannen su yana yin lissafin ne a wata hanya (a ƙasa ko sama da 0). A lokaci guda, an saita adadin lambobi ta mai amfani da kansa, saboda wanda zai iya samun kowane sakamakon sha'awa.