Lapho wenza ukubala okuhlukahlukene, kwesinye isikhathi udinga ukuphindaphinda inombolo ngamaphesenti. Isibonelo, lokhu kubalwa kusetshenziswa ekunqumeni inani lesibonelelo sokuhweba ngamanani wemali, ngesibonelelo esaziwayo samaphesenti. Ngeshwa, lokhu akuwona umsebenzi olula kuwo wonke umsebenzisi. Ake sichaze ukuthi singaphinda kanjani isibalo ngamaphesenti ku-Microsoft Excel.
Ukuphindaphindeka kwenombolo ngePhesenti
Eqinisweni, amaphesenti ayikhulu enombolo. Okusho ukuthi, lapho bethi, ngokwesibonelo, amahlandla ayisi-13% - kuyafana amahlandla ama-0.13. Ku-Excel, le nkulumo ingabhalwa njengo- "= 5 * 13%." Ukubalwa, le nkulumo kumele ibhalwe emgqeni wefomula, noma kunoma isiphi iseli eshidi.
Ukuze ubone umphumela esitokisini esikhethiwe, vele ucindezele inkinobho ethi ENTER kukhibhodi yekhompyutha.
Cishe ngendlela efanayo, ungahlela ukuphindaphindeka ngamaphesenti asethi emininingwane ye-tabular. Ukuze wenze lokhu, siba esitokisini lapho kuzobukiswa khona imiphumela yokubala. Kungaba kuhle ukuthi leli seli libe kumugqa ofanayo nenani okufanele libalwe. Kepha lokhu akuyona imfuneko. Sibeka uphawu olulinganayo ("=") kule seli, bese sichofoza kuseli equkethe inombolo yoqobo. Ngemuva kwalokho, sibeka uphawu lokuphindaphindayo ("*"), bese sithayipha kukhibhodi inani lamaphesenti esifuna ukuphindaphindeka inani lelo. Ekupheleni kwerekhodi ungakhohlwa ukufaka isenti ("%").
Ukuze ubonise umphumela ephepheni, chofoza inkinobho ENTER.
Uma kunesidingo, lesi senzo singasetshenziswa kwamanye amaseli ngokumane sikopishe ifomula. Isibonelo, uma idatha isetafuleni, khona-ke ume ekhoneni elingezansi kweseli lapho ifomula iqhutshelwa kuyo, bese inkinombolo yenkinobho yesinxele icindezelwe, uyihudulele phansi ekugcineni kwetafula. Ngakho-ke, ifomula izokopishelwa kuwo wonke amaseli, futhi kufanele ungayishayeli ngesandla ukubala ukuphindaphindwa kwezinombolo ngamaphesenti athile.
Njengoba ukwazi ukubona, ngokuphindaphindeka kwenombolo ngamaphesenti kwiMicrosoft Excel, akufanele kube nezinkinga ezikhethekile hhayi kuphela zabasebenzisi abanolwazi, kodwa nakwabaqalayo. Lo mhlahlandlela uzokusiza ekuqondeni le nqubo ngaphandle kwezinkinga.
