Ayyukan na Excel na Sassaukar yana sa sauƙi a zagaye lamba a sama ko zuwa ƙasa zuwa 5, 10, ko wani ƙimar da aka ƙayyade.
Alal misali, aikin za a iya amfani dashi don yadawa ko rage farashin abubuwa zuwa mafi kusa:
- biyar cents (0.05)
- goma shanti (0.10)
don kaucewa samun maganin pennies (0.01) a matsayin canji.
Ba kamar tsarin tsarawa wanda ya ba ka damar canja yawan adadin wurare marasa kyau ba tare da canza ainihin tantanin salula ba, aikin MROUND, kamar sauran ayyuka na zagaye na Excel, yana canza darajar bayanai.
Yin amfani da wannan aikin don tattara bayanan bayanai, sabili da haka, zai shafi sakamakon lissafi.
Halin Sakamakon Sakamakon Sakamako da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Rigon don aikin ROUNDDOWN shine:
= MROUND (Number, Multiple)
Magana akan aikin shine:
Lambar - (da ake buƙata) lambar da za a ɗauka ta sama ko ƙasa zuwa lamba mafi kusa
- Wannan hujja na iya ƙunsar ainihin bayanai don tasowa ko yana iya kasancewa tantancewar salula akan wurin da aka sanya bayanai a cikin takardun aiki .
Magani - (da ake buƙata) aikin yana ƙaddamar da ƙidayar Magana a sama ko ƙasa zuwa nau'in mafi yawan wannan darajar.
Abubuwan da za a lura game da muhawarar aiki shine:
- Magana da yawa za su kasance daidai da alamar - ko dai mai kyau ko korau. Idan ba haka ba, aikin zai dawo da #NUM! kuskure a tantanin halitta.
- idan Lamba da Multiple jayayya ne duka korau, aikin zai dawo da lambar mummunan a cikin tantanin halitta kamar yadda aka nuna a jere hudu a cikin hoton da ke sama.
- idan an saita Magana mai yawa zuwa ƙananan (0), aikin zai dawo da darajar sifili a cikin tantanin halitta kamar yadda aka nuna a jere na bakwai a cikin hoton da ke sama.
Misalan Ayyukan Kasuwanci
A cikin hoton da ke sama, don misalai shida na farko, lambar 4.54 ta ɗora sama ko ƙasa ta hanyar aikin MROUND ta amfani da wasu nau'ikan dabi'u don hujjojin factor kamar 0.05, 0.10, 5.0, 0, da 10.0.
Ana nuna sakamakon a shafi na C da kuma hanyar da ke samar da sakamakon a shafi na D.
Ƙunƙasa Up ko Ƙasa
Bisa ga fayil na Fayil na Excel, yadda aikin ya ƙayyade ko a zagaye na ƙarshe (lambar zagaye) sama ko ƙasa ya dogara ne akan sauran da ke haifar da rarraba Tambaya ta Magana mai yawa.
- Idan wannan sakamakon yafi ko kuma daidai da rabi darajar Magana mai yawa, aikin yana zagaye na ƙarshe (daga sifilin zero).
- Idan wannan sakamakon ya zama ƙasa da rabi darajar Magana mai yawa, aikin yana zagaye na ƙarshe (zuwa siffar baƙi).
Misalai guda biyu na ƙarshe - a jere 8 da 9 na hoton - ana amfani da su don nuna yadda aikin yake gudana a sama ko ƙasa.
- A jere na 8, tun da Magana mai yawa shine lamba guda ɗaya, lambar 2 ta zama lambar zagaye a lamba 12.50 a cikin cell A8. Tunda 2.5 ya daidaita da rabi darajar Magana ta Multiple (5.00), aikin yana ɗaukar sakamakon har zuwa 15.00, wanda shine mafi kusa kusan na 5.00 fiye da 12.50.
- A jere na 9, tun da 2.49 ba kasa da rabi darajar Magana ta Multiple (5.00), aikin yana ɗaukar sakamakon zuwa 10.00, wanda shine mafi kusa kusan na 5.00 kasa da 12.49.
Misali Amfani da Hanyoyin MUTANE na Excel
Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:
- Rubuta cikakken aikin: kamar = MROUND (A2.0.05) a cikin sashin layi na aiki.
- Zabi aikin da ƙididdiga ta amfani da akwatin maganganu na MROUND.
Mutane da yawa sun fi sauƙi don amfani da akwatin maganganu don shigar da muhawarar aiki kamar yadda yake kula da haɗin aikin - irin su magunguna da ke aiki a matsayin masu rarrabe tsakanin gardama.
Matakan da ke ƙasa suna amfani da akwatin maganganu don shigar da aikin zagaye cikin cell C2 na misali a sama.
- Danna sel B2 don sa shi tantanin halitta .
- Danna kan Rubutun shafin shafin rubutun .
- Danna kan maɓallin Math & Trig don buɗe jerin abubuwan da aka sauke aikin.
- Danna Kunnawa a cikin jerin don bude akwatin maganganun.
- A cikin akwatin maganganu, danna kan Lambar .
- Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin halitta kamar Magana mai lamba .
- A cikin akwatin maganganu, danna kan Maɓallin Multiple .
- Rubuta a cikin 0.05 - lambar a A2 za a zagaye sama ko ƙasa zuwa ƙananan mafi kusa na 5 cents.
- Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.
- Darajar 4.55 ya kamata ya bayyana a cikin tantanin halitta B2, wanda shine mafi kusa mafi yawa na 0.05 ya fi girma fiye da 4.54.
- Lokacin da ka danna kan tantanin halitta C2 cikakken aikin = MROUND (A2, 0.05) ya bayyana a cikin maɓallin tsari a sama da takardun aiki.