Ifomula yokushintsha iphesenti isetshenziswa kakhulu ku-Excel. Isibonelo, ukubala ushintsho lwanyanga zonke noma oluphelele.
Ushintsho lwanyanga zonke
- Khetha iseli C3 bese ufaka ifomula eboniswe ngezansi.
- Khetha iseli C3 futhi usebenzise ifomethi yephesenti kuyo.
- Ukuze ungaphindi isinyathelo sokuqala nesesi-1 izikhathi eziyishumi ngaphezulu, khetha iseli C3, chofoza ekhoneni elingezansi kwesokudla bese uyihudulela phansi kuseli С13.
- Hlola ukuthi konke kuhambe kahle yini.
Ushintsho olujwayelekile
- Ngokufanayo, singabala ingqikithi yoshintsho. Kulokhu silungisa ireferensi yeseli V2. Gqamisa iseli D3 bese ufaka ifomula eboniswe ngezansi.
- Khetha iseli D3 futhi usebenzise ifomethi yephesenti kuyo.
- Gqamisa iseli D3, chofoza ekhoneni elingezansi kwesokudla bese uyihudulela phansi kuseli D13.
- Hlola ukuthi konke kuhambe kahle yini.
Incazelo: Uma sihudulela (sikopisha) ifomula phansi, inkomba ephelele ($B$2) ihlala ingashintshiwe, kodwa inkomba ehlobene (B3) iyashintsha - B4, B5, B6, njll. Lesi sibonelo singase sibe nzima kakhulu kuwe kulesi sigaba, kodwa ikhombisa ezinye izici eziwusizo nezinamandla i-Excel enazo.