Lapho uqhuba izibalo ezahlukahlukene, kwesinye isikhathi kuyadingeka ukwandisa inani lamaphesenti amaningi. Isibonelo, lokhu kubalwa kusetshenziswa ekunqumeni inani lokukhokhiswa kwezohwebo ngamagama emali, ngamaphesenti aziwayo wesibonelelo. Ngeshwa, hhayi umsebenzi ngamunye kuwumsebenzi olula. Ake sinqume ukuthi ungawandisa kanjani amaphesenti enombolo kuhlelo lweMicrosoft Excel.
Ukuphindaphinda kwamaphesenti enombolo
Eqinisweni, iphesenti liyingxenye yekhulu lenombolo. Lokho wukuthi, lapho bethi, ngokwesibonelo, amahlanu andiswe ngo-13% - kufana no-5 ophindwe ngu-0.13. Kuhlelo lwe-Excel, le nkulumo ingabhalwa ngokuthi "= 5 * 13%". Ukubala, le nkulumo kumele ibhalwe ngentambo yefomula, noma kunoma yisiphi iseli eshidini.
Ukubona umphumela kuseli elikhethiwe, vele ucindezele inkinobho ethi Faka kwikhibhodi yekhompyutha.
Cishe ngendlela efanayo, ungenza ukuphindaphindwa kwamaphesenti asetheliwe wedatha ye-tabular. Kulokhu, siba iseli lapho kuzokhonjiswa khona imiphumela yokubalwa. Kuhle ukuthi ngabe leli seli likumugqa ofanayo nenombolo yokubalwa. Kepha lesi akusona isidingo. Sibeka kuleli ngqa isibonakaliso sokulingana ("="), bese uqhafaza esitokisini, esiqukethe inombolo yomthombo. Ngemuva kwalokho, beka uphawu lokuphindaphinda ("*"), bese ufaka amaphesenti amaphesenti kwikhibhodi ofuna ukwandisa inani. Ekupheleni kwerekhodi, ungakhohlwa ukubeka uphawu lwamaphesenti ("%").
Ukuze ukhiphe umphumela ekhasini chofoza inkinobho ethi Faka.
Uma kunesidingo, lesi senzo singasetshenziswa kwamanye amaseli ngokumane sikopishe ifomula. Isibonelo, uma idatha itholakala etafuleni, yanele nje ukuvuka ungene ebhokisini elingezansi kwesokudla seseli, lapho ifomula iqhutshwa khona, kwathi lapho igundane lesobunxele lifungelwe, lifeze kuze kube sekupheleni itafula. Ngakho-ke, ifomula izokopishelwa kuwo wonke amaseli, futhi akudingekile ukuyishayela ngesandla ukubala ukuphindaphindwa kwezinombolo ngamaphesenti athile.
Njengoba ubona, ngokuphindaphinda amaphesenti enombolo kuhlelo lweMicrosoft Excel, akufanele kube nezinkinga ezikhethekile hhayi kuphela kubasebenzisi abanolwazi, kodwa ngisho nama-Newbies. Lo mhlahlandlela uzokuvumela ukuthi ufunde le nqubo ngaphandle kwezinkinga.