Kuchotsa manambala awiri kapena angapo ku Excel ndi ndondomeko
Kuchotsa manambala awiri kapena angapo ku Excel muyenera kupanga fomu .
Mfundo zofunika kukumbukira zokhudzana ndi Excel mafomu zikuphatikizapo:
- Mafomu mu Excel nthawi zonse amayamba ndi chizindikiro chofanana ( = );
- Njirayi imayikidwa mu selo komwe mukufuna yankho kuoneka;
- Chizindikiro chochotseramo ku Excel ndi dash (-);
- Fomuyi imatsirizidwa mwa kukanikiza fungulo lolowamo pa makiyi.
Kugwiritsira ntchito zizindikiro za magulu mu mafomu
Ngakhale kuti n'zotheka kuika manambala mwachindunji (monga momwe tawonedwera mu mzere 2 wa chitsanzo), ndi bwino kuti mulowetse deta m'maselo ogwirira ntchito ndikugwiritsa ntchito maadiresi kapena mavesi a maselowo mu mzere (mzere 3 mwachitsanzo).
Pogwiritsira ntchito mafotokozedwe a selo m'malo mndondomeko yeniyeni, pamapeto pake, ngati pakufunika kusintha deta , ndi nkhani yosavuta yochotsera deta m'maselo mmalo molembanso machitidwewo.
Zotsatira za fomuyi zidzasinthidwa pokhapokha ngati deta isintha.
Njira ina ndi kusakaniza mafotokozedwe a maselo ndi data enieni (mzere 4 wa chitsanzo).
Kuwonjezera Kugonana
Excel ili ndi dongosolo la ntchito zomwe zimatsatira pofufuza zomwe masamu amachita kuti achite poyamba.
Mofanana ndi kalasi ya masamu, dongosolo la ntchito lingasinthidwe pogwiritsira ntchito malemba monga zitsanzo zowonekera m'mizere isanu ndi isanu ndi umodzi pamwambapa.
Kuchotsa Chitsanzo Chitsanzo
Monga momwe tawonera mu chithunzi pamwambapa, chitsanzo ichi chimapanga ndondomeko mu selo D3 yomwe imachotsa deta mu selo A3 kuchokera ku deta ku B3.
Fomu yomalizidwa mu selo D3 idzakhala:
= A3 - B3
Lembani ndi Dinani pa Cell References
Ngakhale kuti mungathe kulembera ndondomeko yomwe ili pamwambayi mu selo D3 ndikukhala ndi yankho lolondola, ndibwino kugwiritsa ntchito mfundo ndikusindikiza kuti muwonjeze mafotokozedwe a maselo a ma fomu kuti muchepetse kuthekera kwa zolakwika zomwe zimapangidwa polemba mu selo lolakwika zolemba.
Lembani ndi kubola zikuphatikizapo kusinkhasinkha maselo omwe ali ndi deta ndi pointer ya mouse kuti uwonjeze mawonekedwe a selo pa fomu.
- Lembani chizindikiro chofanana ( = ) mu selo D3 kuti muyambe kukonzekera.
- Dinani pa selo A3 ndi ndondomeko ya phokoso kuwonjezera kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chofanana.
- Lembani chizindikiro chosasuntha ( - ) mutatulutsira selo.
- Dinani pa selo B3 kuti muwonjezere kuti selo loyang'ana pa ndondomeko pambuyo pa chizindikiro chochepa.
- Lembani fungulo lolowamo lolowera mubokosilo kuti mukwaniritse chithunzicho.
- Yankho 10 liyenera kupezeka mu selo E3.
- Ngakhale kuti yankho lachitsulo likuwonetsedwa mu selo E3, kudumpha pa seloyo kudzawonetsera machitidwe mu barolo lazenera pamwamba pa tsamba.
Kusintha Dongosolo la Fomu
Poyesa ubwino wogwiritsira ntchito ma selo pamasom'pamaso, pangani nambala yanu mu selo B3 (monga kuchoka 5 mpaka 4) ndi kukanikiza fungulo lolowamo ku Enter . Yankho la selo D3 liyenera kusinthidwa kuti liwonetse kusintha kwa deta mu selo B3.
Kupanga Mafomu Ovuta Kwambiri
Kuwonjezera njirayi kuti muphatikize ntchito zina (monga kugawa kapena kuwonjezera) monga momwe tawonedwera mu mzere wachisanu ndi chiwiri, pitirizani kuwonjezerapo olemba masamu omwe akutsatiridwa ndi ndondomeko ya selo yomwe ili ndi deta yatsopano.
Kuchita, yesani chitsanzo ichi ndi sitepe ya njira yovuta kwambiri .