Sauke lambobi biyu ko fiye a Excel tare da takamammen
Don ƙaddamar da lambobi biyu ko fiye a Excel kana buƙatar ƙirƙirar tsari .
Abubuwan da ke da mahimmanci suyi tunawa game da siffofin Excel sun hada da:
- Formulas a cikin Excel sukan fara da daidai alamar ( = );
- Ana amfani da wannan tsari a cikin tantanin halitta inda kake son amsawa ta bayyana;
- Ƙididdigar da aka sanya a cikin Excel shine dash (-);
- 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 (kamar yadda aka nuna a jere na 2 na misalin), yawanci ya fi kyau don shigar da bayanai cikin sassan ayyukan aiki sa'annan amfani da adiresoshin ko nassoshi na waɗannan sel a cikin tsari (jere 3 na misali).
Ta amfani da bayanan salula fiye da ainihin bayanan a cikin wata hanya, daga baya, idan ya zama dole don canza bayanai , to sauƙi ne na maye gurbin bayanai a cikin kwayoyin maimakon sake rubutawa da wannan tsari.
Sakamakon dabarar za ta sabunta ta atomatik sau ɗaya bayanan canje-canjen.
Wani zaɓi shine don haɗar tantancewar salula da ainihin bayanai (jere na 4 na misali).
Adding Parenthesis
Excel yana da tsari na aiki wanda ya biyo bayan yin la'akari da ayyukan aikin ilmin lissafi don aiwatarwa da farko a cikin wani tsari.
Kamar yadda a cikin lissafin lissafi, ana iya canza tsarin yin aiki ta amfani da iyayenku kamar misalai da aka nuna a layuka biyar da shida a sama.
Misalan Ƙira misali
Kamar yadda aka gani a cikin hoton da ke sama, wannan misali ya haifar da wata ƙira a cikin cell D3 wanda zai rabu da bayanai a cikin cell A3 daga bayanai a B3.
Kayan da aka gama a cell D3 zai kasance:
= A3 - B3
Matsa kuma Danna kan Siffofin Siffar
Ko da yake yana yiwuwa a rubuta irin wannan labaran zuwa cikin cell D3 kuma ana samun amsar daidai, ya fi kyau a yi amfani da ma'ana kuma danna don ƙara tantanin tantanin halitta akan ƙididdiga don rage girman yiwuwar kurakuran da aka gina ta hanyar bugawa cikin kwayar maras kyau tunani.
Matsa kuma danna kunna danna kan kwayoyin da ke dauke da bayanai tare da maɓallin linzamin kwamfuta don ƙara ƙirar salula zuwa wannan tsari.
- Rubuta alamar daidai ( = ) a cikin cell D3 don fara tsarin.
- Danna kan A3 tare da maɓallin linzamin kwamfuta don ƙara wannan tantancewar salula zuwa wannan tsari bayan daidai alamar.
- Rubuta alamar m ( - ) bayan bayanan salula.
- Danna kan tantanin halitta B3 don ƙara wannan tantancewar salula zuwa wannan tsari bayan alamar musa.
- Latsa maɓallin shigarwa a kan keyboard don kammala tsari.
- Amsar 10 ya kamata a kasance a cell E3.
- Ko da yake an nuna amsar wannan tsari a cikin salula E3, danna kan tantanin halitta zai nuna nau'in dabara 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, yi canji zuwa lamba a cikin cell B3 (kamar su daga 5 zuwa 4) kuma danna maɓallin Shigar da ke keyboard. Amsar a cikin cell D3 ya kamata ta atomatik sabuntawa don yin la'akari da sauyawa cikin bayanai a cikin cell B3.
Ƙirƙirar ƙirar ƙwararrun ƙira
Don fadada wannan tsari don haɗawa da wasu ayyuka (kamar rarraba ko tarawa) kamar yadda aka nuna a jere na bakwai, kawai ci gaba da ƙara ƙwayar ilimin ilmin lissafi mai biyo bayan ƙirar salula wanda ya ƙunshi sabon bayanai.
Don yin aiki, gwada wannan matakan mataki zuwa mataki na tsari mai mahimmanci .