Uma wenza izibalo ezihlukahlukene, ngezinye izikhathi kuyadingeka ukuba wanda inombolo ngenani lephesenti. Isibonelo, lokhu kubalwa kusetshenziswa ekunqumeni inani lemali yokuhweba ngokwemali, ngephesenti eyaziwayo ye-premium. Ngeshwa, lokhu akuwona umsebenzi olula kuwo wonke umsebenzisi. Ake sichaze indlela yokwandisa inombolo ngephesenti ku-Microsoft Excel.
Inombolo ephindaphindiwe ngephesenti
Eqinisweni, iphesenti liyingxenye eyikhulu yenombolo. Okusho ukuthi, uma bethi, isibonelo, amahlanu aphindwe ngo-13% afana nokuphindaphinda 5 ngenombolo 0.13. Ku-Excel, le nkulumo ingabhalwa ngokuthi "= 5 * 13%". Ukubala le nkulumo udinga ukubhala emgqeni wefomula, noma kunoma isiphi iseli kushidi.
Ukuze ubone umphumela kuseli elikhethiwe, vele ucindezele inkinobho ENTER ekhibhodi yekhompyutha.
Ngendlela efanayo, ungahlela ukuphindaphindiwe ngephesenti elungisiwe lemininingwane ye-tabular. Ukwenza lokhu, siba esitokisini lapho imiphumela yokubala izoboniswa khona. Kungaba kuhle ukuthi le seli libe emgqeni ofanayo nenombolo ezobala. Kodwa lokhu akuyona into ebalulekile. Sifaka uphawu olulinganayo ("=") kule seli, bese uchofoze kuseli eliqukethe inombolo yokuqala. Khona-ke, sibeka uphawu lokuphindaphinda ("*"), bese uthayipha ikhibhodi inani lephesenti esifuna ukuliphindaphinda inombolo. Ekupheleni kokurekhoda, ungakhohlwa ukubeka uphawu lwephesenti ("%").
Ukuze ubonise umphumela kushidi, chofoza inkinobho ENTER.
Uma kudingeka, lesi senzo singasetshenziswa kwamanye amaseli, ngokukopisha ifomula kuphela. Isibonelo, uma idatha itholakala etafuleni, kwanele nje ukuma ekhoneni elingezansi elingakwesokudla leseli lapho ifomula liqhutshwa khona, futhi inkinobho yegundane lesokunxele igcinwe phansi, yibambe phansi ekugcineni kwetafula. Ngakho-ke, ifomula izokopishwa kuwo wonke amaseli, futhi ngeke kudingeke uyiqhube ngesandla ukuzela ukuphindaphinda kwezinombolo ngephesenti elithile.
Njengoba ubona, ngokuphindaphinda kwenombolo ngephesenti ku-Microsoft Excel, akufanele kube nezinkinga ezithile kuphela kubasebenzisi abanolwazi, kodwa ngisho nakwaqalayo. Le mhlahlandlela izokuvumela ukuthi ukwazi kahle le nqubo.
