Yadda za a rabu da shi a cikin Shafukan Lissafin Google

Yi amfani da Fassarar Rubutun Google don ƙaddamar da lambobi biyu ko fiye

01 na 02

Yin amfani da Formula don ƙaddara Lissafi a cikin Shafukan Lissafin Google

Domin ƙaddamar da lambobi biyu ko fiye a cikin Shafukan Wallafa na Google, kana buƙatar ƙirƙirar takarda .

Mahimman mahimmanci su tuna game da Maƙunsar Bayani na Google:

• Formulas a cikin Shafukan Rubutun Google kullum sukan fara tare da alamar daidai ( = ).
• Alamar daidai ita ce taɓa shiga cikin tantanin halitta inda kake son amsawa ta bayyana.
• Ƙididdigar da aka sanya a cikin Shafukan Rubutun Google shine dash (-).
• An kammala wannan tsari ta latsa maɓallin shigarwa a kan keyboard ko ta hanyar motar da tantanin halitta zuwa wani tantanin halitta tare da linzamin kwamfuta ko maɓallin arrow a kan keyboard.

Ganin Sakamakon, Ba Dokar ba

Da zarar an shiga cikin sashin layi, za a nuna amsar ko sakamakon wannan tsari a cikin tantanin halitta maimakon dabarar kanta.

Ganin Formula, Ba Amsa ba

Akwai hanyoyi biyu masu sauƙi don duba wannan tsari bayan an shigar da ita:

1. Danna sau ɗaya tare da maɓallin linzamin kwamfuta akan tantanin halitta dauke da amsar - ana nuna wannan tsari a cikin maɓallin tsari a sama da takardun aiki.
2. Danna sau biyu a kan tantanin halitta dauke da wannan tsari - wannan yana sanya shirin a cikin yanayin gyare-gyaren kuma yana baka dama ka ga kuma canza tsari a tantanin halitta kanta.

02 na 02

Ƙara inganta tsarin ƙirar

Ko da yake shigar da lambobi kai tsaye a cikin wani tsari, kamar = 20 - 10 na aiki, ba shine hanya mafi kyau don ƙirƙirar ƙira ba.

Hanyar mafi kyau ita ce:

1. Shigar da lambobin da za a rabu da su cikin sassan kayan aiki na dabam;
2. Shigar da sanannun tantancewar sel don waɗannan kwayoyin da ke dauke da bayanai a cikin takaddun tsari.

Amfani da Siffofin Siffar a cikin Formulas

Shafukan Lissafi na Google yana da dubban kwayoyin halitta a cikin takarda ɗaya. Don ci gaba da lura da su duka kowannensu yana da adireshi ko tunani wanda aka yi amfani dashi don gano wurin da tantanin halitta yake a cikin takardun aiki.

Waɗannan halayen cell sune hade da harafin shafi na tsaye da lambar jeri na kwance tare da harafin shafi a kowane lokaci an rubuta ta farko - kamar A1, D65, ko Z987.

Ana iya amfani da waɗannan halayen tantanin halitta don gano inda ake amfani da bayanan da aka yi amfani dasu a cikin wata maƙira. Shirin ya karanta bayanan salula sannan kuma matosai a bayanan da ke cikin wadannan kwayoyin cikin wuri mai dacewa a cikin tsari.

Bugu da ƙari, sabunta bayanai a cikin tantanin halitta wanda aka rubuta a cikin wata mahimman tsari a cikin tsarin da aka amsa ta atomatik an sabunta.

Bayyanawa a Data

Bugu da ƙari, yin bugawa, ta amfani da ma'ana kuma danna (danna tare da maɓallin linzamin kwamfuta) a kan kwayoyin da ke dauke da bayanai za'a iya amfani dashi don shigar da kalmomin da aka yi amfani da su a cikin siffofin.

Point da danna suna da amfani wajen rage kurakurai da ta haifar da shigar da kurakurai yayin shigar da sassan layi.

Alal misali: Raƙa Ƙidaya Biyu A Yi amfani da Formula

Matakan da ke ƙasa suna rufe yadda za a ƙirƙira tsarin dabarar da ke cikin cell C3 a cikin hoton da ke sama.

Shigar da Formula

Don cirewa daga 10 daga 20 kuma samun amsar ya bayyana a cell C3:

1. Danna maɓallin C3 tare da maɓallin linzamin kwamfuta don sa shi tantanin halitta ;
2. Rubuta alamar daidai ( = ) a cell C3;
3. Danna kan A3 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan daidai alamar;
4. Rubuta alamar m ( - ) bayan bin tantanin halitta A1;
5. Danna dan B3 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan alamar musa;
6. Latsa maɓallin shigarwa a kan keyboard
7. Amsar 10 ya kamata a kasance a cell C3
8. Don ganin wannan tsari, danna maɓallin C3 a sake, ana nuna wannan tsari a cikin maƙallin ƙira a sama da takardun aiki

Canza Sakamakon Formula

1. Don gwada darajar amfani da bayanan salula a cikin wani tsari, canza lambar a cell B3 daga 10 zuwa 5 kuma danna maɓallin shigarwa akan keyboard.
2. Amsar a C3 C3 ya kamata ta sabunta ta atomatik zuwa 15 don yin la'akari da canji a cikin bayanai.

Fadada tsarin

Don fadada wannan tsari don haɗawa da ƙarin ayyuka - irin su Ƙari, ƙaddamarwa, ko ƙarin rarraba da aka nuna a cikin layuka hudu da biyar a cikin misalin - kawai ci gaba da ƙara ƙwayar lissafin ilimin lissafi da kuma bayanan sirri wanda ya ƙunshi bayanai.

Ayyuka na Ta'idodin Lissafin Google

Kafin ka haɗu da ayyukan daban-daban na ilmin lissafi, tabbas ka fahimci tsari na ayyukan da Shafukan yanar gizon Google ke biyo bayan yin la'akari da tsari.