Njengoba e "Eksele" ukubala amaphesenti: imiqondo esemqoka

Namuhla, abaningi abasebenzisa ikhompyutha abanesifiso umbuzo kanjani "Eksele" ukubala amaphesenti. Lokhu kuyiqiniso ngoba ama-spreadsheet ngokuvamile aqukethe idatha ku izibalo. Uma kuziwa ku-Excel, ngokuvamile ithinta phezu iphesenti kanye amaphesenti umehluko.

isithakazelo 101

Nakuba Excel sikwazi ukwenza izinto eziningi, uhlelo akakwazi ukufundisa izibalo wena. Ngakho-ke, ulwazi oluthile ayisisekelo okudingeka ube nawo khona. Ukukhombisa inombolo ngesimo isithakazelo ku-Excel, kumele sebenzisa eziklanyelwe lolu format. Ukuyisebenzisa, ukhethe amaseli ukuba ngaphansi ufometha, bese uchofoza ku- "Amaphesenti" eqenjini "inombolo" ithebhu "Ekhaya" (ibekwe eteyipini). Ukukhuluma mayelana nendlela "Eksele" ukubala isithakazelo, siphawula ukuthi ngokushesha lokhu kwenziwa ngokusebenzisa inhlanganisela ashisayo ukhiye Ctrl + Shift +%.

Ku-Excel, ukubaluleka base njalo egcinwe ku ifomu ledesimali. Ngakho, ngisho noma usebenzisa ukuma ekhethekile kokubonisa yini amaphesenti (10%), kuba okwakufanekiselwa yenani isizinda. Ngamanye amazwi, i-Excel njalo wenza izibalo Inani ledesimali (0,1). Ukuze uphinde uhlole ukuthi, uyikhethe, cindezela u-Ctrl + 1 bese nibheka amasampuli ensimini "imikhakha Jikelele".

imiqondo eyisisekelo

Ukufometha iphesenti kungase kubonakale kancane kuyinkimbinkimbi. Ngakho-ke, ukuze uqonde ukuthi ukubala amaphesenti Excel, kufanele ucabangele okulandelayo.

Ifomethi amagugu ekhona isicelo lwenani iphesenti kuseli kakade idatha, i-Excel esandisa inombolo 100 futhi unezela% uphawu ekupheleni. Lokhu kuholela kulokho kudideka, ngakho kumelwe ngokucophelela ukuze uqonde ukuthi kwenzekani.

Ake sithi uthayipha 10 kuseli A2, bese ukusebenzisa format%. Ngenxa Excel ubonisa inani ngeembuyabuyelelo 100 ukukhombisa ke njengoba amaphesenti (khumbula ukuthi 1% - lokhu ingenye ingxenye endaweni engamakhulu), uzobona ukuthi 1000% siboniswa kuseli, kunokuba 10%. Ukuze usombulule le nkinga, ungakwazi ukubala inani layo njengoba amaphesenti kwasekuqaleni. Isibonelo, uma ufaka ifomula = 10/100 A2, Excel uyonika umphumela njengoba 0.1 cell. Uma ungakwazi ke ukufometha idatha idesimali, inombolo ziyobonakala njengoba 10% - njengoba ungase ulindele. Ungaphinda futhi ufake inombolo ifomu idesimali ngqo iseli, okungukuthi, ukungena 0.1, bese ukusebenzisa format iphesenti. Lokhu kuzosiza esimweni uma ufuna ithuba, njengasezulwini "Excel" engeza isithakazelo noma uthathe nezinye izenzo nabo.

Empty iseli format: Excel iziphatha ngendlela ehlukile uma ukufometha amaseli zangaphambi ezingenalutho, bese ufaka izinombolo. Izinombolo elilingana nesikhulu kunabo 1, is iguqulwe yentshisekelo ezenzakalelayo; izinombolo esingaphansi 1, engewona nokho negative, kuthiwa iphindwe 100 ukuguqula ukuba amaphesenti. Ngokwesibonelo, uma uthayipha 10 noma 0.1 kuseli kabusha, ungabona ukubaluleka 10% yavela. Manje, uma uthayipha 0.1, uzobona ukuthi ukuboniswa value izinguquko. Ingase futhi akubonise kanjani "Eksele" susa isithakazelo.

Ifomethi njengoba uthayipha: Uma ufaka i-10% ngqo iseli, Excel ngeke ngokuzenzakalelayo ukusebenzisa format iphesenti. Lokhu kuyasiza uma ufuna ukungena per cent eyodwa kuphela eshidini, isibonelo, inani lentela noma ikhomishini.

isitatimende isithakazelo

Kanjani futhi uma ufaka noma iyiphi amafomula ku-Excel, kufanele uqale ukubhala ukubaluleka, uthayipha setshwayo (=) kuseli ekhethiwe. Ifomula eziyisisekelo indlela "Eksele" ubale isithakazelo dlozinga lo: = B2 / C2.

Esinye isibonelo kungaba ukubala more xaka. Ngakho, uma ufuna ukunciphisa ethile ku-25% uma uzama ukusebenzisa isaphulelo, ifomula yakho ngeke zithole leli fomu elilandelayo: = B2 * (1-C2). Ukwandisa ngo-25%, kufanele itsatfwe uphawu lokususa ku-formula in the plus.