Bonisa amaphesenti ku-Excel

Kulesi sifundo esincane uzothola ulwazi oluningi oluwusizo mayelana ifomethi yephesenti ku-Excel. Uzofunda ukuthi ungayishintsha kanjani ifomethi yedatha ekhona Amaphesenti, ukusetha kanjani ukuboniswa kwamaphesenti kuseli, kanye nendlela yokushintsha izinombolo ngokuzenzakalelayo zibe amaphesenti uma zifakwe ngesandla.

Ku-Microsoft Excel, ukubonisa amanani njengamaphesenti kulula kakhulu. Ukuze wenze lokhu, khetha iseli elilodwa noma amaningi bese uchofoza inkinobho Isitayela Samaphesenti (ifomethi yephesenti) esigabeni Inombolo (Inombolo) amathebhu Ikhaya (Ekhaya):

Ungakwenza ngokushesha nakakhulu ngokucindezela isinqamuleli sekhibhodi Ctrl+Shift+%. I-Excel izokukhumbuza ngale nhlanganisela isikhathi ngasinye lapho uhambisa phezulu inkinobho. Isitayela Samaphesenti (ifomethi yephesenti).

Yebo, Ifomethi Yephesenti ku-Excel ingasethwa ngokuchofoza okukodwa. Kodwa umphumela uzohluka kakhulu kuye ngokuthi usebenzisa ukufometha kumanani akhona noma amaseli angenalutho.

• Fometha amanani akhona njengamaphesenti
• Faka ifomethi yephesenti kumaseli angenalutho
• Bonisa izinombolo njengamaphesenti ngokushesha njengoba uthayipha
• Amaqhinga lapho ubonisa amaphesenti ku-Excel

Fometha amanani akhona njengamaphesenti

Uma ufaka isicelo Ifomethi Yephesenti Kumaseli asevele equkethe amanani ezinombolo, i-Excel iphindaphinda lawo manani ngo-100 futhi yengeze uphawu lwephesenti (%) ekugcineni. Ngokombono we-Excel, lokhu kulungile, njengoba i-1% iyingxenye yekhulu.

Nokho, ngezinye izikhathi lokhu kuholela emiphumeleni engalindelekile. Isibonelo, uma iseli A1 iqukethe inombolo 20 futhi ufaka isicelo kule seli Ifomethi Yephesenti, khona-ke ngenxa yalokho uzothola i-2000%, hhayi i-20% njengoba cishe ubufuna.

Ungalivimba kanjani iphutha:

• Uma iseli etafuleni lakho linezinombolo ngendlela evamile yenombolo, futhi udinga ukuzishintsha zibe Amaphesenti, qala uhlukanise lezi zinombolo ngo-100. Isibonelo, uma idatha yakho yokuqala ibhalwe kukholamu A, ungafaka ifomula kuseli B2. =A2/100 bese uyikopishela kuwo wonke amaseli adingekayo ekholomu B. Okulandelayo, khetha yonke ikholomu B bese uyisebenzisa kuyo Ifomethi Yephesenti. Umphumela kufanele ube into enjengale:Ungakwazi ke esikhundleni samafomula akukholomu B ufake amanani, bese uwakopishela kukholomu A bese ususa ikholomu B uma ungasayidingi.
• Uma udinga kuphela ukuguqula amanye amanani abe yifomethi yephesenti, ungawafaka ngesandla ngokuhlukanisa inombolo ngo-100 futhi uyibhale njengedesimali. Isibonelo, ukuze uthole inani elingu-28% kuseli A2 (bona isithombe esingenhla), faka inombolo engu-0.28, bese usebenzisa kuyo. Ifomethi Yephesenti.

Faka ifomethi yephesenti kumaseli angenalutho

Sibonile ukuthi ukuvezwa kwedatha ekhona kakade kusipredishithi se-Microsoft Excel kushintsha kanjani lapho uguqulela ifomethi yenombolo elula Amaphesenti. Kodwa kwenzekani uma uqala ukufaka isicelo esitokisini Ifomethi Yephesenti, bese ufaka inombolo kuyo mathupha? Kulapho i-Excel ingaziphatha ngokuhlukile.

• Noma iyiphi inombolo elingana noma enkulu kuno-1 izomane ibhalwe ngophawu lwe-%. Isibonelo, inombolo yesi-2 izobhalwa njenge-2%; 20 - njengo-20%; 2,1 - njengo-2,1% njalonjalo.
• Izinombolo ezingaphansi kuka-1 ezibhalwe ngaphandle kuka-0 ukuya kwesokunxele sephoyinti ledesimali zizophindwa ngo-100. Isibonelo, uma uthayipha ,2 kuseli enephesenti lokufometha, uzobona inani elingu-20% njengomphumela. Nokho, uma uthayipha kukhibhodi 0,2 kuseli efanayo, inani lizobhalwa ngokuthi 0,2%.

Bonisa izinombolo njengamaphesenti ngokushesha njengoba uthayipha

Uma ufaka inombolo engu-20% (nophawu lwephesenti) kuseli, i-Excel izoqonda ukuthi ufuna ukubhala inani njengephesenti futhi uguqule ngokuzenzakalelayo ifomethi yeseli.

Isaziso esibalulekile!

Uma usebenzisa ukufometha kwephesenti ku-Excel, sicela ukhumbule ukuthi lokhu akuyona into engaphezu kwesethulo esibonakalayo senani langempela lezibalo eligcinwe kuseli. Eqinisweni, inani lephesenti lihlala ligcinwe njengedesimali.

Ngamanye amazwi, u-20% ugcinwa njengo-0,2; I-2% igcinwa njenge-0,02 njalonjalo. Uma kwenziwa izibalo ezihlukahlukene, i-Excel isebenzisa la manani, okungukuthi amafrakshini edesimali. Gcina lokhu engqondweni lapho wenza amafomula abhekisela kumaseli anamaphesenti.

Ukubona inani langempela eliqukethwe kuseli elinalo Ifomethi Yephesenti:

1. Chofoza kuso bese ukhetha kusuka kumenyu yokuqukethwe Fometha Amaseli noma cindezela inhlanganisela Ctrl + 1.
2. Ebhokisini lengxoxo elivelayo Fometha Amaseli (Ifomethi Yeseli) bheka indawo Context (Isampula) ithebhu Inombolo (Inombolo) esigabeni General (General).

Amaqhinga lapho ubonisa amaphesenti ku-Excel

Kubonakala sengathi ukubala nokubonisa idatha njengephesenti kungomunye wemisebenzi elula kakhulu esiyenzayo nge-Excel. Kodwa abasebenzisi abanolwazi bayazi ukuthi lo msebenzi awuhlali ulula.

1. Setha isibonisi kwinombolo oyifunayo yezindawo zamadesimali

Nini Ifomethi Yephesenti ezisetshenziswa ezinombolweni, i-Excel 2010 kanye no-2013 ibonisa inani lazo lifinyezwe enambeni yonke, futhi kwezinye izimo lokhu kungase kudukise. Isibonelo, setha ifomethi yephesenti kuseli engenalutho bese ufaka inani elingu-0,2% kuseli. Kwenzenjani? Ngibona u-0% etafuleni lami, nakuba ngazi kahle ukuthi kufanele kube ngu-0,2%.

Ukuze ubone inani langempela hhayi inani eliyindilinga, udinga ukwandisa inani lezindawo zamadesimali okufanele i-Excel ibonise. Kwalokhu:

1. Vula ibhokisi lengxoxo Fometha Amaseli (Fometha amaseli) usebenzisa imenyu yokuqukethwe, noma cindezela inhlanganisela yokhiye Ctrl + 1.
2. Khetha isigaba Amaphesenti (Iphesenti) bese usetha inombolo yezindawo zamadesimali ezivezwa kuseli ngendlela othanda ngayo.
3. Uma yonke into isilungile, chofoza OKngoba izinguquko zizosebenza.

2. Gqamisa Amanani Amibi Ngokufometha

Uma ufuna amanani anegethivu aboniswe ngokuhlukile, njengefonti ebomvu, ungasetha ifomethi yenombolo yangokwezifiso. Phinda uvule ibhokisi Fometha Amaseli (Fometha amaseli) bese uye kuthebhu Inombolo (Inombolo). Khetha isigaba Custom (Wonke Amafomethi) bese ufaka esikhaleni uhlobo omunye wemigqa elandelayo:

• 00%;[Red]-0.00% or 00%;[Okubomvu]-0,00% - bonisa amanani amaphesenti angalungile ngokubomvu futhi ubonise izindawo zedesimali ezi-2.
• 0%;[Okubomvu]-0% or 0%; [Kraukozela]-0% - bonisa amanani amaphesenti anegethivu ngokubomvu futhi ungabonisi amanani ngemuva kwephoyinti ledesimali.

Ungafunda okwengeziwe ngale ndlela yokufometha kusithenjwa se-Microsoft, esihlokweni sokubonisa izinombolo ngefomethi yamaphesenti.

3. Fometha Amanani Amaphesenti Angemahle ku-Excel Ngokufometha Okunemibandela

Uma kuqhathaniswa nendlela yangaphambilini, ukufometha okunemibandela ku-Excel kuyindlela evumelana nezimo kakhulu ekuvumela ukuthi usethe noma iyiphi ifomethi yeseli equkethe inani lephesenti elingalungile.

Indlela elula yokudala umthetho wokufometha onemibandela ukuya kumenyu Ukufomatha okunemibandela > Gqamisa imithetho yamaseli > Ngaphansi kwe (Ukufometha Okunemibandela > Imithetho Yokukhetha Iseli > Ngaphansi Ko...) bese ufaka u-0 ensimini Fometha amaseli ANGAPHANSI KUNE (Fometha amaseli angu-LESS)

Okulandelayo, kuhlu lokudonsela phansi, ungakhetha eyodwa yezinketho ezijwayelekile ezihlongozwayo noma uchofoze Ifomethi yangokwezifiso (Ifomethi yangokwezifiso) ekugcineni kwalolu hlu futhi wenze ngendlela othanda ngayo yonke imininingwane yefomethi yeseli.

Nazi ezinye izinketho zokusebenza Ifomethi yephesenti idatha ivula i-Excel. Ngethemba ukuthi ulwazi oluzuzwe kulesi sifundo luzokusindisa ekuphathweni ikhanda okungadingekile esikhathini esizayo. Ezihlokweni ezilandelayo, sizongena sijule esihlokweni samaphesenti ku-Excel. Uzofunda ukuthi iziphi izindlela ongazisebenzisa ukuze ubale intshisekelo ku-Excel, ufunde amafomula okubala ukuguqulwa kwamaphesenti, iphesenti lengqikithi, inzalo ehlanganisiwe, nokuningi.

Hlala ubukele futhi ujabule ngokufunda!