Isifundo sokukhipha amaphesenti enombolweni ku-Excel

Imvamisa, ezibalweni ezehlukene zezibalo, kusetshenziswa ukususa amaphesenti enombolweni ethile. Izinkampani eziningi, isibonelo, zisebenzisa ukususa ukuze zibeke inani lomkhiqizo, ukubala inzuzo eyenziwe, njalonjalo.

Kulesi sifundo, sizozama ukukutshela kalula ngangokunokwenzeka mayelana nendlela yokukhipha kahle iphesenti enombolweni ku-Excel. Kuyaphawuleka ukuthi umsebenzi ngamunye kukhona indlela. Asiqhubekele kokuqukethwe.

Susa amaphesenti enombolweni

Ukuze ususe iphesenti enombolweni ethile, okokuqala udinga ukubala inani eliphelele lephesenti enombolweni ethile, bese ukhipha inani eliwumphumela kweyokuqala.

Ku-Excel, lesi senzo sezibalo sibukeka kanje:

= Idijithi (iseli) – Idijithi (iseli) * Amaphesenti (%).

Isibonelo, ukususa u-23% enombolweni engu-56 kubhalwe kanje: 56-56 * 23%.

Ufaka amanani akho kunoma iyiphi iseli yamahhala yetafula, vele uchofoze inkinobho ethi "Enter", bese umphumela ophelile uzovela kuseli ekhethiwe.

Susa amaphesenti kuthebula eliqediwe

Kodwa yini okufanele uyenze uma idatha isivele ifakiwe etafuleni, futhi ukubala ngesandla kuzothatha isikhathi esiningi nomzamo?

1. Ukususa iphesenti kuwo wonke amaseli ekholomu, kwanele ukukhetha iseli yokugcina yamahhala emgqeni ofuna ukubala kuwo, bhala uphawu oluthi “=", bese uchofoza kuseli ofuna ukususa kulo iphesenti, bese ubhala uphawu “-” kanye nenani lephesenti elidingekayo, ungakhohlwa ukubhala uphawu oluthi “%” ngokwalo.

   

   Okulandelayo, cindezela ukhiye othi “Enter”, futhi ngokoqobo ngemva komzuzwana umphumela uzovela kuseli lapho ifomula ifakwe khona.

   

   Ngakho sisanda kukhipha iphesenti kuseli eyodwa. Manje ake senze inqubo ngokuzenzakalelayo futhi sisuse ngokushesha iphesenti elifunekayo kuwo wonke amanani eseli kukholamu ekhethiwe. Ukuze wenze lokhu, chofoza kwesokunxele ekhoneni elingezansi kwesokudla seseli lapho ukubala kwenziwa khona ngaphambilini, bese ubamba lelikhona, vele uhudule iseli ngefomula uye phansi ekupheleni kwekholomu noma kububanzi obufunayo.

   

   Ngakho-ke, umphumela wokukhipha iphesenti elithile kuwo wonke amanani kukholomu uzobalwa ngokushesha futhi ubekwe endaweni yawo.

   

2. Kwenzeka ukuthi ithebula aliqukethe amanani aphelele kuphela, kodwa futhi ahlobene, okungukuthi sekuvele kukhona ikholomu enamaphesenti agcwele ahilelekile ekubalweni. Kulokhu, ngokufanayo nenketho ecatshangelwe ngaphambili, sikhetha iseli yamahhala ekugcineni komugqa bese sibhala ifomula yokubala, sishintsha amanani wephesenti ngezixhumanisi zeseli eliqukethe iphesenti.

   

   Okulandelayo, cindezela "Faka" futhi sithola umphumela oyifunayo kuseli esilidingayo.

   

   Ifomula yokubala ingahudulelwa phansi emigqeni esele.

   

Susa amaphesenti kuthebula % elingashintshi

Ake sithi sineseli elilodwa kuthebula eliqukethe iphesenti okudingeka lisetshenziswe ukubala ikholomu yonke.

Kulokhu, ifomula yokubala izobukeka kanje (usebenzisa iseli G2 njengesibonelo):

Qaphela: Izimpawu ezithi “$” zingabhalwa ngesandla, noma ngokuhambisa ikhesa phezu kweseli ngamaphesenti efomula, cindezela inkinobho ethi “F4”. Ngale ndlela, uzolungisa iseli ngamaphesenti, futhi ngeke ishintshe lapho welula ifomula iye phansi kweminye imigqa.

Bese ucindezela "Faka" futhi umphumela uzobalwa.

Manje usungakwazi ukwelula iseli ngefomula ngendlela efana nezibonelo zangaphambilini kuyo yonke imigqa.

Isiphetho

Kulesi sihloko, kucatshangelwe izindlela ezithandwa kakhulu nezilula kakhulu, indlela yokukhipha iphesenti elithile kokubili kunani elithile nakukholomu enamanani agcwele. Njengoba ubona, ukwenza izibalo ezinjalo kulula kakhulu, umuntu angakwazi ukuzibamba kalula ngaphandle kwamakhono akhethekile ekusebenzeni ku-PC naku-Excel ikakhulukazi. Ukusebenzisa lezi zindlela kuzokwenza lula umsebenzi ngezinombolo futhi wonge isikhathi sakho.