Hoton zuwa gefen hagu na misalai kuma ya ba da bayani ga yawan sakamakon da Google Ayyukan Shafukan Gizon ya dawo ta aikin ROUNDUP don bayanai a shafi A na takaddun aiki. Sakamakon, wanda aka nuna a shafi na C, ya dogara ne akan girman ƙididdigar lissafi - ƙarin bayani a ƙasa.
01 na 02
Ayyukan Shafukan Google 'ROUNDUP Function
Lissafin Lissafi a cikin Shafukan Lissafin Google
Hoton da ke sama yana nuna misalai kuma ya ba da bayani ga yawan sakamakon da Google Ayyukan Shafukan Lissafi ya dawo ta aikin ROUNDUP don bayanai a cikin sashin A na takardun aiki.
Sakamakon, wanda aka nuna a shafi na C, ya dogara ne akan girman ƙididdigar lissafi - ƙarin bayani a ƙasa.
Ƙungiyar ROUNDUP da Magana
Haɗin aikin yana nufin layout na aikin kuma ya haɗa da sunan aikin, shafuka, da muhawara.
Rigon don aikin ROUNDUP shine:
= ROUNDUP (lambar, ƙidaya)
Magana akan aikin shine:
lambar - (da ake buƙatar) darajar da za a ɗaura
- 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 .
ƙidaya - (zaɓin) yawan wurare masu tsabta don barin
- idan an kawar da hujjojin ƙidaya , aikin yana ɗaukar darajar har zuwa lambar mafi kusa
- idan aka ƙidaya lissafin gardama zuwa 1, alal misali, aikin zai bar kalma daya kawai zuwa dama na ƙin ƙaddamarwa kuma yana zagaye zuwa lambobi na gaba
- idan ƙididdigar ƙididdiga ta kasance mummunan, an cire dukkan wurare masu ƙazantawa kuma aikin yana ɗaukar lambar lambobi zuwa hagu na ƙimar decimal sama
- Alal misali, idan an saita tamanin lissafin ƙidaya zuwa -1 , aikin zai cire dukkan lambobi zuwa dama na maɓallin decimal kuma zagaye lambar farko zuwa gefen hagu na maɓallin decimal har zuwa 10 - misalin 3 a cikin hoton sama
- idan an saita darajar lissafin gardama zuwa -2 , aikin zai cire dukkan lambobi zuwa dama na maɓallin decimal kuma zagaye na farko da na biyu lambobi zuwa hagu na ƙaddamarwa zuwa 100 - misali 5 a cikin hoton da ke sama
ROUNDUP Ayyukan Gano
Ayyukan ROUNDUP:
- Ana amfani dashi don rage darajar ta wani adadin lambobi na wurare marasa kyau ko lambobi;
- za a yi zagaye na zagaye gaba daya;
- ya canza darajar bayanai a cikin tantanin halitta - ba kamar tsarin tsarawa wanda ya ba ka izinin canza yawan adadin wurare da aka nuna ba tare da canza ainihin ƙimar salula ba;
- yana rinjayar sakamakon lissafi saboda wannan canji a cikin bayanai.
- Koyaushe zane daga zane. Lambobi marasa maƙasudin, ko da yake suna da karfin darajar ta aikin, ana kiran su a ɗaure (misalai 4 da 5 a cikin hoto a sama).
02 na 02
Shafukan Lissafin Google 'ROUNDUP Function Mataki na Mataki Mataki
Misali: Yin amfani da aikin ROUNDUP a cikin Shafukan Lissafin Google
Kamar yadda aka gani a hoton da ke sama, wannan misali zai yi amfani da aikin ROUNDUP don rage lambar a cikin salula A1 zuwa wurare guda biyu. Bugu da ƙari, zai ƙara darajar lambar zagaye ta daya.
Don nuna sakamakon ɗaukar lambobin lambobi yana da lissafi, duka lambar asali da ƙaddamarwa za a ninka ta 10 da kuma sakamakon da aka kwatanta.
Shigar da Bayanan
Shigar da wadannan bayanan cikin wadanda aka sanya Kwayoyin.
Cell Data A1 - 242.24134 B1 - 10Shigar da aikin ROUNDUP
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.
- Danna kan salula A2 don sa shi tantanin aiki - wannan shine inda za a nuna sakamakon ROUNDUP
- Rubuta daidai alamar (=) bi da sunan aikin aiki
- Yayin da kake bugawa, akwatin zane - zane yana nuna tare da sunayen ayyukan da suka fara tare da harafin R
- Lokacin da sunan ROUNDUP ya bayyana a cikin akwati, danna sunan tare da maɓallin linzamin kwamfuta don shigar da sunan aikin kuma buɗe sashin zagaye a cikin cell A2
Shigar da jayayyar Magana
- Tare da siginan kwamfuta dake bayan bayanan zagaye, kunna kan salula A1 a cikin takardun aiki don shigar da wannan tantanin salula a cikin aikin a matsayin Magana mai lamba
- Bayan bin tantanin halitta, rubuta maƙiraƙi ( , ) don aiki a matsayin mai raba tsakanin gardama
- Bayan nau'in takaddama yana daya "2" a matsayin ƙididdigar ƙidaya don rage yawan wurare mara kyau don darajar A1 daga biyar zuwa uku
- Rubuta takalma na rufewa " ) " don kammala abubuwan da ake gudanarwa
- Latsa maɓallin shigarwa akan keyboard don kammala aikin
- Amsar 242.25 ya kamata ya bayyana a cell A2
- Lokacin da ka danna kan salula A2 cikakken aikin = ROUNDUP (A1, 2) ya bayyana a cikin maɓallin tsari a sama da takardun aiki
Yin amfani da Maɓallin Rounded a Lissafi
A cikin hoton da ke sama, an tsara darajar tantanin halitta C1 don nuna kawai lambobi uku don sa lambar ta fi sauƙi don karantawa.
- Danna kan tantanin halitta C1 don sa shi tantanin halitta mai aiki - wannan shine inda za'a shigar da nau'in ƙaddamarwa
- Rubuta alamar daidai don fara da dabara
- Danna kan salula A1 don shigar da wannan tantanin halitta a cikin tsari
- Rubuta alama (*) - alamar alama don ƙaddara a cikin Shafukan Rubutun Google
- Danna sel B1 don shigar da wannan tantanin halitta a cikin tsari
- Latsa maɓallin shigarwa a kan keyboard don kammala tsari
- Amsar ita ce 2,422,413 ya kamata ya bayyana a cell C1
- Rubuta lambar 10 a cell B2
- Danna kan tantanin halitta C1 don sa shi tantanin halitta mai aiki.
- Kwafi zancen a cikin C1 zuwa cell C2 ta amfani da Jawabin Fill ko Kwafi da Manna
- Amsar 2,422.50 ya kamata ya bayyana a cell C2.
Sakamakon daban-daban yana haifar da kwayoyin halitta C1 da C2 - 2,422.413 vs. 2,422.50 yana nuna sakamakon ɗaukar lambobi zai iya samun lissafi, wanda zai iya zama muhimmin adadi a wasu yanayi.