Division Formulas, # DIV / O! Kuskuren Formula, da Daidaita Ƙira
Don raba lambobi biyu kana buƙatar ƙirƙirar wata matsala tun da babu wani aikin DIVIDE a Excel.
Mahimman mahimmanci suyi tunani game da siffofin Excel:
- Formulas a cikin Excel sukan fara da daidai alamar ( = );
- Alamar daidai tana shiga cikin tantanin halitta inda kake son amsawa;
- Alamar rarraba ita ce slash (s) na gaba ( / );
- An kammala tsari ta latsa maɓallin Shigar da ke keyboard.
Amfani da Siffofin Siffar a cikin Formulas
Ko da yake yana yiwuwa a shigar da lambobi kai tsaye a cikin wani tsari, yana da kyau a shigar da bayanai a cikin fayilolin aikin aiki sannan a yi amfani da adiresoshin ko ƙididdigar waɗannan sel a cikin tsari kamar yadda aka nuna a cikin hoto a sama.
Ta amfani da bayanan salula - irin su A1 ko C5 - maimakon ainihin bayanan a cikin wani tsari, daga baya, idan ya zama dole don canza bayanai , yana da sauƙi na maye gurbin bayanai a cikin kwayoyin maimakon sake rubutawa da wannan tsari.
Yawanci, sakamakon wannan tsari zai sabunta ta atomatik sau ɗaya bayanan canje-canjen.
Formule Division Misalin
Kamar yadda aka gani a jere na 2 a cikin hoton da ke sama, wannan misali ya haifar da wata ƙira a cikin sel B2 wanda ke rarraba bayanan a cikin salula A2 ta bayanan A3.
Ƙarshen dabara a cikin tantanin halitta B2 zai kasance:
= A2 / A3
Shigar da Bayanan
- Rubuta lambar 20 a cell A2 kuma latsa maɓallin Shigar da ke keyboard;
- Rubuta lambar 10 a cikin salula A3 kuma danna maɓallin Shigar .
Shigar da Formula Ta Amfani
Ko da yake yana yiwuwa a rubuta irin wannan tsari kawai
= A2 / A3
cikin cell B2 kuma suna da amsar daidai na nuni 2 a wannan tantanin halitta, yana da kyau a yi amfani da ma'ana don ƙara ƙididdigar sel zuwa ƙididdiga don rage girman yiwuwar kurakurai da aka halicce ta ta yin rubutu a cikin ɓarwar ƙwayar salula mara kyau.
Bayyanawa ya shafi danna tantanin halitta dauke da bayanai tare da maɓallin linzamin kwamfuta don ƙara tantancewar salula zuwa wannan tsari.
Don shigar da dabara:
- Rubuta alamar daidai a cikin cell B2 don fara tsarin.
- Danna maɓallin A2 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan daidai alamar.
- Rubuta alamar siginar - slash gaba - ( / ) cikin cell D1 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 D1 tun lokacin da kashi 20 ya raba ta 10 yana daidai da 2;
- Ko da yake ana ganin amsar a cell D1, danna kan wannan 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 sabunta ta atomatik zuwa 4 don yin la'akari da sauyawa cikin bayanai a cikin salula A3.
# DIV / O! Kuskuren Formula
Kuskuren mafi kuskure da ke hade da ayyukan raga a Excel 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 .
Ƙididdige Ƙididdiga tare da Formulas Formats
A kashi ne kawai kwatanta tsakanin lambobi biyu da suke yin amfani da aikin 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 aiki na rarraba - ko kwance - ya kasa ƙasa, Excel yana wakilta, ta hanyar tsoho, a matsayin ƙima, kamar yadda aka nuna a jere na 4, inda aka saita adadi zuwa 10, lambar maƙalar zuwa 20, kuma mahaɗin daidai yake. zuwa 0.5.
Wannan sakamakon zai iya canza zuwa kashi bisa dari ta canza canji a tantanin tantanin halitta zuwa kashi dari daga tsoho Janar - kamar yadda aka nuna ta 50% sakamakon da aka nuna a cikin b5 B5 a cikin hoton da ke sama.
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 aka tsara tsarin tsarawa a cikin Excel, shirin yana ƙara yawan ƙimar ƙima ta 100 kuma yana ƙara da alamar ƙimar.
Ƙirƙirar ƙirar ƙwararrun ƙira
Don fadada siffofi a cikin hoton don hada ƙarin ayyuka - kamar ƙaddara ko ƙari - kawai ci gaba da ƙara ƙwayar lissafin ilimin lissafi da kuma bayanan sirrin da ke dauke da sabon bayanai.
Kafin ka haɗu da aiki daban-daban na ilmin lissafi a cikin wani tsari, duk da haka, yana da muhimmanci a fahimci tsari na ayyukan da Excel ke biyo bayan yin la'akari da tsari.
Don yin aiki, gwada wannan matakan mataki zuwa mataki na tsari mai mahimmanci .