Ifomula Yokukhula Kwephesenti ku-Excel

Abasebenzisi be-Excel bavame ukubhekana nolwazi lwamaphesenti. Kunemisebenzi eminingi nama-opharetha akuvumela ukuthi ulawule amaphesenti. Esihlokweni, sizohlaziya ngokuningiliziwe indlela yokusebenzisa ifomula yokukhula kwephesenti kusihleli sespredishithi.

Ibala amaphesenti kusipredishithi

Umhleli wespredishithi muhle ngoba senza izibalo eziningi ngokwaso, futhi umsebenzisi udinga kuphela ukufaka amanani okuqala futhi abonise isimiso sokubala. Ukubala kwenziwa kanje: Ingxenye/Yonke = Amaphesenti. Imiyalelo enemininingwane ibukeka kanje:

Lapho usebenza ngolwazi lwephesenti, iseli kufanele lifomethwe ngendlela efanele.

1. Chofoza iseli oyifunayo ngenkinobho yegundane elingakwesokudla.
2. Kumenyu yokuqukethwe ekhethekile evelayo, khetha inkinobho ebizwa ngokuthi "Fometha Amaseli".

3. Lapha udinga ukuchofoza kwesokunxele engxenyeni ethi "Fometha", bese usebenzisa into ethi "KULUNGILE", gcina izinguquko ezenziwe.

Ake sibheke isibonelo esincane ukuze siqonde ukuthi singasebenza kanjani ngephesenti yolwazi kusihleli sespredishithi. Imiyalelo enemininingwane ibukeka kanje:

1. Sinamakholomu amathathu etafuleni. Eyokuqala ikhombisa igama lomkhiqizo, eyesibili ikhombisa izinkomba ezihleliwe, kanti eyesithathu ikhombisa ezangempela.

2. Emgqeni D2 sifaka ifomula elandelayo: = C2 / B2.
3. Sisebenzisa imiyalelo engenhla, sihumusha inkambu ye-D2 ibe ifomu lephesenti.
4. Sisebenzisa umaka wokugcwalisa okhethekile, selula ifomula efakiwe kuyo yonke ikholomu.

5. Ilungile! Isihleli sespredishithi ngokwaso sibale amaphesenti okusetshenziswa kohlelo lomkhiqizo ngamunye.

Bala Ushintsho Lwephesenti Usebenzisa Ifomula Yokukhula

Usebenzisa umhleli wespredishithi, ungasebenzisa inqubo yokuqhathanisa amasheya angu-2. Ukwenza lesi senzo, ifomula yokukhula inhle kakhulu. Uma umsebenzisi edinga ukuqhathanisa amanani ezinombolo A no-B, ifomula izobukeka kanje: =(BA)/A=umehluko. Ake sibheke yonke into ngokuningiliziwe. Imiyalelo enemininingwane ibukeka kanje:

1. Ikholomu A iqukethe amagama ezimpahla. Ikholomu B iqukethe inani layo lango-Agasti. Ikholomu C iqukethe inani layo likaSepthemba.
2. Zonke izibalo ezidingekayo zizokwenziwa kukholamu D.
3. Khetha iseli D2 ngenkinobho yegundane kwesokunxele bese ufaka ifomula elandelayo lapho: =(C2/B2)/B2.

4. Hambisa isikhombisi ekhoneni elingezansi kwesokudla seseli. Kuthathe isimo sophawu oluncane oluhlanganisa nombala omnyama. Sisebenzisa inkinobho yegundane engakwesokunxele ecindezelwe, selula le fomula kuyo yonke ikholomu.
5. Uma amanani adingekayo ekukholomu eyodwa yomkhiqizo othile isikhathi eside, ifomula izoshintsha kancane. Isibonelo, ikholomu B iqukethe ulwazi lwazo zonke izinyanga zokuthengisa. Kukholomu C, udinga ukubala izinguquko. Ifomula izobukeka kanje: =(B3-B2)/B2.

6. Uma amanani ezinombolo edinga ukuqhathaniswa nedatha ethile, khona-ke ireferensi yesici kufanele yenziwe iphelele. Isibonelo, kuyadingeka ukuqhathanisa zonke izinyanga zokuthengisa noJanuwari, bese ifomula izothatha ifomu elilandelayo: =(B3-B2)/$B$2. Ngereferensi ephelele, uma uhambisa ifomula kwamanye amaseli, izixhumanisi zizolungiswa.

7. Izinkomba ezinhle zibonisa ukwanda, kuyilapho izinkomba ezingezinhle zibonisa ukwehla.

Ukubalwa kwezinga lokukhula kusihleli sespredishithi

Ake sibhekisise ukuthi singabala kanjani izinga lokukhula kusihleli sespredishithi. Izinga lokukhula/lokukhula lisho ushintsho enanini elithile. Ihlukaniswe yaba izinhlobo ezimbili: eziyisisekelo kanye chain.

Izinga lokukhula kochungechunge lisho isilinganiso samaphesenti kunenkomba yangaphambilini. Ifomula yesilinganiso sokukhula kweketango imi kanje:

Izinga lokukhula eliyisisekelo libhekisela esilinganisweni sephesenti kuya kusilinganiso esiyisisekelo. Ifomula yezinga lokukhula eyisisekelo imi kanje:

Inkomba yangaphambilini inkomba yekota edlule, inyanga, njalo njalo. Isisekelo yindawo yokuqala. Izinga lokukhula kweketango liwumehluko obaliwe phakathi kwezinkomba ezi-2 (zamanje nezidlule). Ifomula yesilinganiso sokukhula kweketango imi kanje:

Izinga lokukhula eliyisisekelo umehluko obaliwe phakathi kwezinkomba ezi-2 (okwamanje kanye nesisekelo). Ifomula yezinga lokukhula eyisisekelo imi kanje:

Ake sicabangele yonke into ngokuningiliziwe ngesibonelo esithile. Imiyalelo enemininingwane ibukeka kanje:

1. Isibonelo, sinepuleti elinjalo elibonisa imali engenayo ngekota. Umsebenzi: Bala izinga lokukhula nokukhula.

2. Ekuqaleni, sizofaka amakholomu amane azoqukatha amafomula angenhla.

3. Sesivele sitholile ukuthi amanani anjalo abalwa njengephesenti. Sidinga ukusetha ifomethi yephesenti yamaseli anjalo. Chofoza ebangeni elidingekayo ngenkinobho yegundane elingakwesokudla. Kumenyu yokuqukethwe ekhethekile evelayo, khetha inkinobho ebizwa ngokuthi "Fometha Amaseli". Lapha udinga ukuchofoza inkinobho yegundane kwesokunxele engxenyeni ethi "Fometha", bese usebenzisa inkinobho ethi "KULUNGILE", londoloza izinguquko ezenziwe.
4. Sifaka ifomula enjalo yokubala izinga lokukhula kweketango futhi silikopishe kumaseli aphansi.

5. Sifaka ifomula enjalo yezinga eliyisisekelo lokukhula kweketango futhi silikopishe kumaseli aphansi.

6. Sifaka ifomula enjalo yokubala izinga lokukhula kweketango futhi silikopishe kumaseli aphansi.

7. Sifaka ifomula enjalo yezinga eliyisisekelo lokukhula kweketango futhi silikopishe kumaseli aphansi.

8. Ilungile! Senze ukubalwa kwazo zonke izinkomba ezidingekayo. Isiphetho esisekelwe esibonelweni sethu esiqondile: engxenyeni yesi-3, i-dynamics impofu, njengoba izinga lokukhula lingamaphesenti ayikhulu, futhi ukukhula kuhle.

Isiphetho neziphetho mayelana nokubalwa kokukhula kwephesenti

Sithole ukuthi umhleli wespredishithi i-Excel ikuvumela ukubala izinga lokukhula njengephesenti. Ukuze usebenzise le nqubo, udinga nje ukufaka wonke amafomula adingekayo kumaseli. Kuyaphawuleka ukuthi amaseli lapho umphumela odingekayo uzoboniswa khona kufanele aqale aguqulwe abe ifomethi yephesenti kusetshenziswa imenyu yokuqukethwe kanye nento ethi “Fometha Amaseli”.