01 na 03
Ayyukan Shafukan Lissafi na Google 'ROUND Function
Za'a iya amfani da aikin ROUND don rage darajar ta wani adadin ƙananan wurare.
A cikin tsari, lambar karshe, lambar ƙidayar, ta ɗaga sama ko ƙasa.
Sharuɗɗa don lambobi masu tarin yawa wanda Google Taswirar ke biyo baya, ya fada;
- Idan darajan lamba zuwa dama na lambar zagaye ya kasa da biyar, ana barin lambar da ke zagaye ba tare da canzawa ba;
- Idan darajar lamba zuwa dama na lambar zagaye yana da biyar ko mafi girma, lambar ƙidayar ta ɗaga ta ɗaya.
Har ila yau, ba kamar tsarin tsarawa wanda ya ba ka izinin canza yawan adadin ƙananan wurare da aka nuna ba tare da canza canjin a tantanin halitta ba, aikin ROUND, kamar ayyukan Google ɗin Shafukan Wizard na sauran ayyuka, yana canza muhimmancin bayanan.
Yin amfani da wannan aikin don tattara bayanan bayanai, sabili da haka, zai shafi sakamakon lissafi.
Hoton da ke sama yana nuna misalai kuma ya ba da bayani ga yawan sakamakon da Google Ayyukan Shafukan Lissafi ya bayarda 'aikin ROUNDDOWN don bayanai a shafi na A na takardun aiki.
Sakamakon, wanda aka nuna a shafi na C, ya dogara akan darajar ƙididdigar lissafi - duba bayanan da ke ƙasa.
02 na 03
Ƙungiyar Harkokin Gwaninta 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:
= ROUNDDOWN (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 cire hujjojin ƙidaya , aikin yana kimanta darajar zuwa lamba mafi kusa
- Idan aka ƙaddamar da hujjojin ƙidaya zuwa 1, misali, aikin zai bar kalma ɗaya kawai zuwa dama na maɓallin decimal kuma yana zagaye shi zuwa lambar da ta gaba
- Idan ƙididdigar ƙididdiga ta kasance mummunan, an cire dukkan wurare na nakasassu kuma aikin yana ɗaga yawan adadin lambobi zuwa gefen hagu na ƙimar decimal zuwa ƙasa
- Alal misali, idan an saita darajar lissafin gardama 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 - misali 2 a cikin hoton sama
- Idan an saita tamanin lissafin ƙidaya zuwa -2 , aikin zai cire dukkan lambobi zuwa dama na maɓallin decimal kuma zagaye na farko da na biyu lambobi zuwa hagu na ƙananan rufin zuwa zuwa 100 - misali 4 a cikin hoto a sama
03 na 03
BABI NA GABATARWA
Ayyukan ROUNDOWN:
- An yi amfani da shi don rage darajar ta ƙayyadadden wurare na wurare marasa kyau ko lambobi;
- Koyaushe yana barin lambar da ba a canzawa ba - kada ya juya shi;
- Ya canza darajar bayanan a cikin tantanin halitta - sabanin tsarin tsarawa wanda ya ba ka izinin canza yawan adadin ƙananan wurare da aka nuna ba tare da canza ainihin ƙimar salula ba;
- Ana rinjayar sakamakon sakamakon lissafi saboda wannan canji a cikin bayanai.
- Koyaushe zane zuwa zane. Lambobi marasa maƙasudin, ko da yake suna da karfin darajar ta wurin aikin, ana kiran su sun kasance a ƙasa (misalai 4 da 5 a cikin hoto a sama).