Ayyuka na Excel MROUND

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:

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

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:

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.

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.

Misali Amfani da Hanyoyin MUTANE na Excel

Zaɓuɓɓukan don shigar da aikin da ƙididdigar sun hada da:

  1. Rubuta cikakken aikin: kamar = MROUND (A2.0.05) a cikin sashin layi na aiki.
  2. 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.

  1. Danna sel B2 don sa shi tantanin halitta .
  2. Danna kan Rubutun shafin shafin rubutun .
  3. Danna kan maɓallin Math & Trig don buɗe jerin abubuwan da aka sauke aikin.
  4. Danna Kunnawa a cikin jerin don bude akwatin maganganun.
  5. A cikin akwatin maganganu, danna kan Lambar .
  6. Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin halitta kamar Magana mai lamba .
  7. A cikin akwatin maganganu, danna kan Maɓallin Multiple .
  8. Rubuta a cikin 0.05 - lambar a A2 za a zagaye sama ko ƙasa zuwa ƙananan mafi kusa na 5 cents.
  9. Danna Ya yi don rufe akwatin maganganu kuma komawa zuwa aikin aiki.
  10. 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.
  11. 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.