Indlela yokuphindaphinda ipesenti kwi-Excele

Anonim

Ukuphindaphinda ipesenti yenani kwiMicrosoft Excel

Xa uqhuba ukubala ezahlukeneyo, ngamanye amaxesha kuyayimfuneko ukuphindaphinda inani lexabiso lepesenti. Umzekelo, olubalo lusetyenziswa ekuqinisekiseni inani le-surchermer kwimigaqo yemali, nepesenti eyaziwayo yesibonelelo. Ngelishwa, hayi kumsebenzisi ngamnye ngumsebenzi olula. Masenze ukuba iphindaphinde ipesenti yenani lesicelo se-Microsoft Excel.

Ukuphindaphinda kwepesenti yenani

Ngapha koko, ipesenti yinxalenye ikhulu lenani. Oko kukuthi, xa besithi, umzekelo, ezintlanu eziphindaphindiweyo nge-13%-ifana ne-5 ephindaphindiweyo linani 0.13. Kwinkqubo ye-Excel, eli binzana lingabhalwa njenge "= 5 * 13%". Ukubala, eli binzana kufuneka libhalwe kwi-formulartring, okanye kuyo nayiphi na iseli.

Ifomula yokuphindaphinda yepesenti yenani lenkqubo ye-Microsoft Excel

Ukubona iziphumo kwiseli ekhethiweyo, cinezela iqhosha le-ENTO kwikhibhodi yekhompyuter.

Isiphumo sokuphindaphinda kwepesenti yenani kwiNkqubo ye-Microsoft Excel

Malunga nendlela efanayo, unokwenza ukuphindaphinda kwipesenti yedatha ye-tabitur. Kule nto, siba sisisele apho iziphumo zobalo ziya kubonakala khona. Eyona nto iya kuba kukuba leseli ikwindawo enye njengenombolo yobalo. Kodwa ayisiyomfuneko. Sibeka kule sel tyhat olinganayo ("="), kwaye ucofe kwiseli, enenombolo yomthombo. Emva koko, faka isibonakaliso esiphindaphindwayo ("*"), kunye nenqaku lexabiso lepesenti kwikhibhodi ofuna ukuphindaphinda inani. Ekupheleni kwengxelo, ungalibali ukubeka uphawu lwepesenti ("%").

Ifomula eyaphindwayo yepesenti yenani kwinkqubo ye-Microsoft ye-Excel kwitafile

Ukukhupha iziphumo ekwiphepha cofa kwiqhosha le-ENTER.

Iziphumo zokuphindaphinda zepesenti yenani kwinkqubo ye-Microsoft Excel kwitafile

Ukuba kukho imfuneko, eli nyathelo linokusetyenziswa kwezinye iiseli ngokukopa nje ifomula. Umzekelo, ukuba idatha ibekwe kwitafile, kwanele nje ukuba unyuke kwi-angle esezantsi yeseli, apho i-formula iqhutywa, kwaye xa igundane lasekhohlo lifungelwe itafile. Ke, ifomula iya kukhuliswa kuzo zonke iiseli, kwaye akuyomfuneko ukuba iqhube ngesandla ukubala ukuphindaphindwa kwamanani kwipesenti ethile.

Ukukhuphela i-formu yokuphindaphinda i-forulation ipesenti yenkqubo yeMicrosoft Excel kwitafile

Njengoko ubona, ngokuphindaphinda ipesenti yenkqubo yeMicrosoft Excel, kungabikho ngxaki zikhethekileyo kungekuphela kwabasebenzisi abanamava, kodwa nakwiim entsha. Esi sikhokelo siya kukuvumela ukuba ufunde le nkqubo ngaphandle kweengxaki.

Funda ngokugqithisileyo