Ƙirƙirar madaidaicin hanyar da za a raba lambobi a cikin Shafukan Shafukan Google
Kamar Excel, Shafukan Lissafi na Google ba su da wani aikin DIVIDE. Maimakon haka, kana buƙatar ƙirƙirar takarda a cikin Shafukan Gidan Google don aiwatar da ayyukan sassan. Wadannan umarnin suna tafiya da ku ta hanyar ƙirƙirar takaddun tsari, ciki har da hanyoyi daban-daban don ƙirƙirar dabarar, kurakurai da za ku iya fuskanta, da kuma yadda za ku yi amfani da maɓallin DIVIDE don sakamakon yawan.
Raba a cikin Shafukan Lissafin Google ta amfani da Formula
Don raba lambobi biyu kana buƙatar ƙirƙirar tsari , tun da babu wani aikin da ke cikin Fassara na Google.
Mahimman mahimmanci su tuna game da Maƙunsar Bayani na Google:
- Formulas ko da yaushe fara tare da daidai ãyã ( = ).
- Alamar daidai tana shiga cikin tantanin halitta inda kake son amsawa.
- Mai aiki na ƙaddamarwa shine slash slash ( / ).
- An kammala tsari ta latsa maɓallin Shigar da ke keyboard.
Amfani da Siffofin Siffar a cikin Formulas
Zai yiwu a shigar da lambobi kai tsaye a cikin wani tsari - kamar yadda aka nuna a layuka biyu da uku a cikin misali a sama.
Zai fi kyau, don shigar da bayanai a cikin fayilolin aikin aiki sa'an nan kuma amfani da adiresoshin ko nassoshin waɗannan kwayoyin a cikin tsarin da aka nuna a cikin layuka hudu zuwa shida a misalin.
Ta amfani da bayanan salula - irin su A2 ko A5 - maimakon ainihin bayanan a cikin wata hanya - daga baya, idan ya zama dole don canza bayanai , yana da sauƙi na maye gurbin bayanan a cikin kwayoyin maimakon sake rubutawa da wannan tsari.
Yawanci, sakamakon wannan tsari zai sabunta ta atomatik sau ɗaya bayanan canje-canjen.
Misalan Matakan Rukunin Matakan
Dabarar a cikin cell B4 na misali:
= A2 / A3
Kawai rarraba bayanai a cikin salula A2 ta hanyar bayanai a A3 don dawo da amsar guda biyu.
Shigar da Formula With Point kuma Danna
Ko da yake yana yiwuwa a rubuta irin wannan tsari kawai
= A2 / A3
A cikin sel B4 kuma suna da amsar daidai na nuni 2 a cikin tantanin, yana da kyau a yi amfani da maɓalli-da-danna ko nunawa don ƙara ƙididdigar sel akan ƙididdiga - musamman tare da ƙayyadaddun tsari.
Yin haka yana rage yiwuwar kurakurai da aka kirkiro ta hanyar bugawa cikin maɓallin ƙwayar salula.
Point da latsa ya shafi danna tantanin halitta dauke da bayanai tare da maɓallin linzamin kwamfuta don ƙara mahimmancin tantancewar salula zuwa wannan tsari.
Don shigar da tsari
- Rubuta = (daidai daidai) a cikin cell B4 don fara da dabara.
- Danna maɓallin A2 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan daidai alamar.
- Rubuta / (alamar rarraba ko slash slash) zuwa cikin cell B4 bayan bayanan salula.
- Danna kan A3 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan siginar rarraba.
- Latsa maɓallin shigarwa a kan keyboard don kammala tsari.
- Amsar 2 ya kamata a kasance a cikin tantanin halitta B4 tun lokacin da raba kashi 20 ya daidaita da 2.
- Kodayake ana ganin amsar a cikin cell B4, danna kan tantanin halitta zai nuna nau'in = A2 / A3 a cikin maɓallin tsari a sama da takardun aiki.
Canza Bayanan Bayanin Samun
Don gwada darajar yin amfani da maƙallan salula a cikin wani tsari, canza lambar a cikin salula A3 daga 10 zuwa 5 kuma danna maballin shigarwa akan keyboard.
Amsar a cikin sel B2 ya kamata ta atomatik ta atomatik zuwa hudu don yin la'akari da sauyawa cikin bayanai a cikin cell A3.
# DIV / O! Kuskuren Formula
Kuskuren mafi kuskure da ke hade da aiki na yanki shine # DIV / O! kuskure kuskure.
Wannan kuskure ɗin yana nuna lokacin da maƙinci a cikin tsari ɗin tsari daidai yake da nau'i - wanda ba a yarda a lissafi na al'ada ba.
Dalilin da ya sa wannan ya faru shi ne cewa an yi amfani da ma'anar tantanin halitta a cikin tsari ko, kamar yadda aka nuna a jere na 3 a cikin hoton da ke sama, an buga wannan maƙasudin zuwa wani wuri ta amfani da cikawa da cikawa da kuma canza maɓallin sakin layi a cikin kuskure .
Ƙidaya Ƙididdiga tare da Formulas Division
Yawanci shine kwatancin kawai tsakanin lambobi biyu da suke yin amfani da aiki na rarraba.
Ƙari musamman, ƙananan juzu'i ko ƙaddarar da aka ƙayyade shi ne ta rarraba adadi ta lamba kuma ƙara yawan sakamakon sakamakon 100.
Nau'in nau'i na nau'i zai zama:
= (Lamba / Ƙidaya) * 100
Lokacin da sakamakon aikin rarraba - ko kwance - ya kasance ƙasa da ɗaya, Googlereadsheets yana wakiltar shi, ta hanyar tsoho, a matsayin adadi, kamar yadda aka nuna a jere biyar, inda:
- An saita adadi zuwa 10.
- Lambar din zuwa 20.
- The quotient ne daidai da 0.5.
Wannan sakamakon zai iya canza zuwa kashi bisa dari ta canza canji a tantanin halitta zuwa kashi dari daga tsoho Tsarin atomatik - kamar yadda aka nuna ta 50% sakamakon da aka nuna a cikin bita B6 na misalin.
Wannan tantanin halitta yana dauke da ma'anar da aka kwatanta da tantanin halitta B4. Bambanci kawai shi ne tsara a kan tantanin halitta.
A sakamakon haka, lokacin da ake amfani da tsarin tsara kashi, shirin yana ƙaruwa da ƙimar ƙima ta 100 kuma yana ƙara ƙididdigar kashi.