Ayyukan Shafukan Lissafin Google 'MROUND aikin yana sa sauƙi a zagaye lamba a sama ko zuwa ƙasa zuwa mafi kusa 5, 10, ko wasu ƙayyadadden ƙayyadaddun.
Alal misali, aikin za a iya amfani da su don haɓaka ko žasa farashin abubuwa zuwa kusan biyar (0.05) ko goma (0.10) don kaucewa yin la'akari da albashi (0.01) a matsayin canji.
Sabanin tsara tsarin da zai ba ka damar canja yawan adadin ƙananan wurare da aka nuna ba tare da canza ainihin tantanin salula ba, aikin MROUND, kamar ayyukan Google ɗin Shafukan Wizard na sauran ayyuka, yana canza darajar bayanai.
Yin amfani da wannan aikin don tattara bayanan bayanai, sabili da haka, zai shafi sakamakon lissafi.
Lura: Don ƙidayar lambobi zuwa sama ko ƙasa ba tare da tantance adadin zagaye ba, yi amfani da ROUNDUP ko ROUNDOWN LOCATIONS a maimakon.
01 na 04
Halin Sakamakon Sakamakon Sakamako da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara .
Haɗin aikin aikin MROUND shine:
= MROUND (darajar, factor)
Magana akan aikin shine:
darajar - (buƙatar) lambar da za a ɗaura 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 .
factor - (da ake buƙata) aikin yana ɗaukar ƙarar gardama a sama ko ƙasa zuwa nau'in mafi yawan wannan darajar.
Abubuwan da za a lura game da muhawarar aiki shine:
- idan an cire hujjojin factor ɗin, kuskuren N / A a cikin tantanin halitta dauke da aikin.
- da mahimmanci da ƙididdigar gardama dole ne wannan alamar ta kasance - ko dai mai kyau ko korau. Idan ba haka ba, aikin zai dawo da #NUM! kuskure a tantanin halitta.
- idan ƙididdiga da darajar ƙididdiga su ne korau, aikin zai dawo da lambar mummunan cikin tantanin halitta kamar yadda aka nuna a jere hudu a cikin hoton da ke sama.
- idan an ƙaddamar da gardamar factor zuwa nauyin (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.
02 na 04
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
Ko lambar da ta rage ko lamba (lambar zagaye) an ɗaga sama ko žasa yana dogara ne akan hujja mai muhimmanci .
- Idan lambar lambobi da lambobi zuwa dama da shi a cikin ƙwararriyar ƙimar ba su da ƙasa da rabi darajar hujjar hujja, aikin yana ɗaukar lambar ƙarshe.
- Idan lambar zagaye da lambobi zuwa dama na shi a cikin ƙwararriyar hujjoji sun fi girma ko kuma daidai da rabi adadin mahimmancin hujja, lamarin zagaye yana kewaye.
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 hujjar factor ita ce lamba guda ɗaya, 2 ɗin ya zama lamarin zagaye a cikin lambobi na 12.50 a cikin cell A8. Tunda 2.5 yana daidaita da rabi adadin mahimmancin hujja (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 rabin darajar hujja na factor (5.00), aikin yana zagaye sakamakon zuwa 10.00, wanda shine mafi kusa da kusan 5.00 kasa da 12.49.
03 na 04
Shigar da aikin GABATARWA
Fayil ɗin Shafukan Google bazai amfani da akwatunan maganganu don shigar da muhawarar aiki kamar yadda ake samu a Excel. Maimakon haka, yana da akwati na nuna kai tsaye wanda ya tashi kamar yadda aikin aikin ya shiga cikin tantanin halitta.
- Shigar da wadannan bayanai zuwa cikin cell A1: 4.54
- Danna kan C2 a cikin takardun aiki don sa shi tantanin aiki - wannan shine inda za a nuna sakamakon MROUND
- Rubuta daidai alamar (=) bi da sunan aikin mround
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunayen ayyukan da suka fara tare da wasika M
- Lokacin da sunan MENE ya bayyana a cikin akwati, danna sunan tare da maɓallin linzamin kwamfuta don shigar da sunan aikin kuma buɗe sashi na zagaye a cikin C2 cell
04 04
Shigar da Magana ta Magana
An shigar da muhawarar aikin MROUND bayan an bude madauri a cikin ƙwayoyin C2.
- Danna kan A2 a cikin takardun aiki don shigar da wannan tantanin halitta a matsayin ƙimar ƙimar
- Shigar da takaddama don yin aiki a matsayin mai raba tsakani tsakanin muhawarar aikin
- Rubuta nau'i na 0.05 don shigar da wannan lambar a matsayin hujja
- Latsa maɓallin shigarwa a kan keyboard don shigar da takalmin rufewa " ) " bayan bayanan aikin kuma don kammala aikin
- 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