Mukati
Muchidzidzo chidiki ichi iwe unowana ruzivo rwakawanda runobatsira nezve percent format muExcel. Iwe unozodzidza maitiro ekuchinja fomati ye data iripo kuti chikamu muzana, maitiro ekuseta kuratidzwa kwezvikamu musero, pamwe nekushandura otomatiki manhamba kusvika muzana kana yapinda nemaoko.
MuMicrosoft Excel, kuratidza kukosha sezvikamu zviri nyore kwazvo. Kuti uite izvi, sarudza sero rimwe kana akawanda uye tinya bhatani Percent Style (muzana chimiro) muchikamu nhamba (Nhamba) tabs Home (Kumba):
Iwe unogona kuzviita nekukurumidza nekudzvanya iyo keyboard nzira Ctrl+Shift+%. Excel ichakuyeuchidza nezvemusanganiswa uyu nguva imwe neimwe yaunofamba pamusoro pebhatani. Percent Style (muzana chimiro).
Ehe, Percent Format muExcel inogona kusetwa nekudzvanya kumwe chete. Asi mhedzisiro ichave yakasiyana zvakanyanya zvichienderana nekuti uri kushandisa fomati kune iripo kukosha kana maseru asina chinhu.
Fomati huripo huripo sezvikamu
Paunonyorera Percent Format Kune maseru anotova nenhamba dzenhamba, Excel inowanza iwo kukosha nezana uye inowedzera chiratidzo chezana (%) kumagumo. Kubva pakuona kweExcel, izvi ndezvechokwadi, sezvo 100% iine zana.
Zvisinei, dzimwe nguva izvi zvinotungamirira kumigumisiro isingatarisirwi. Semuenzaniso, kana sero A1 iine nhamba 20 uye iwe unonyorera kune iyi sero Percent Format, saka semhedzisiro iwe uchawana 2000%, uye kwete 20% sezvaungangoda iwe.
Nzira yekudzivirira kukanganisa:
- Kana sero riri patafura yako riine manhamba mune yakajairika nhamba fomati, uye iwe unofanirwa kudzishandura kuita chikamu muzana, tanga wapatsanura nhamba idzi ne 100. Semuenzaniso, kana data rako rekutanga rakanyorwa mumutsara A, unogona kuisa fomu musero B2. =A2/100 uye woikopa kumaseru ose anodiwa ekoramu B. Zvadaro, sarudza koramu yose B woshandisa pairi Percent Format. Mhedzisiro yacho inofanira kuva seizvi:
Iwe unogona ipapo kutsiva mafomula mumutsara B nemakoshero, wobva waakopa kukoromo A uye wodzima koramu B kana usingachaida. - Kana iwe uchingoda kushandura humwe hutsika kuita muzana fomati, unogona kuzviisa pamaoko nekugovanisa nhamba ne100 nekuinyora sedesimali. Semuenzaniso, kuti uwane kukosha kwe28% muchitokisi A2 (ona mufananidzo uri pamusoro), isa nhamba 0.28, wozoisa pairi. Percent Format.
Iwe unogona ipapo kutsiva mafomula mumutsara B nemakoshero, wobva waakopa kukoromo A uye wodzima koramu B kana usingachaida.Isa mafomati epercent kumasero asina chinhu
Isu takaona kuti kuratidzwa kwe data ragara riripo muMicrosoft Excel spreadsheet inochinja sei kana iwe uchichinja iyo yakapfava nhamba fomati kuita chikamu muzana. Asi chii chinoitika kana iwe ukatanga kuisa kune sero Percent Format, wobva waisa nhamba mairi nemaoko? Apa ndipo apo Excel inogona kuita zvakasiyana.
- Nhamba ipi neipi yakaenzana kana yakakura kudarika 1 inongonyorwa nechiratidzo che%. Semuenzaniso, nhamba 2 yaizonyorwa se2%; 20 - kufanana ne20%; 2,1 - se2,1% uye zvichingodaro.
- Nhamba isingasviki 1 yakanyorwa isina 0 kuruboshwe rwedesimali inozopetwa nezana. Semuenzaniso, kana ukanyora ,2 musero ine percentage formatting, uchaona kukosha kwe20% semhedzisiro. Nekudaro, kana iwe ukanyora pane keyboard 0,2 musero rimwe chete, kukosha kuchanyorwa se 0,2%.
Ratidza nhamba sezvikamu nekukurumidza paunenge uchinyora
Kana iwe ukaisa iyo nhamba 20% (ine chiratidzo chezana) musero, Excel inonzwisisa kuti iwe unoda kunyora kukosha sechikamu uye wotochinja fomati yesero.
Chiziviso chakakosha!
Paunenge uchishandisa mafomati yezana muExcel, ndapota yeuka kuti ichi hachisi chinhu chinopfuura chiratidzo chechimiro cheiyo chaiyo yemasvomhu kukosha yakachengetwa musero. Muchokwadi, iyo muzana kukosha inogara yakachengetwa sedesimali.
Mune mamwe mazwi, 20% inochengetwa se0,2; 2% inochengetwa se0,02 zvichingodaro. Kana maverengero akasiyana-siyana aitwa, Excel inoshandisa hunhu uhu, kureva zvikamu zvedesimali. Ramba uchifunga izvi paunenge uchigadzira mafomula anoreva maseru ane zvikamu.
Kuona kukosha chaiko kuri musero rine Percent Format:
- Tinya-kurudyi pairi uye kubva pane zviri mukati menyu sarudza Fomati Masero kana kudzvanya musanganiswa Ctrl + 1.
- Mubhokisi rebhokisi rinoonekwa Fomati Masero (Sero Format) tarisa nzvimbo yacho chiratidza zvizhinji (Sample) tab nhamba (Nhamba) muchikamu General (General).
Tricks paunenge uchiratidza mapeji muExcel
Zvinoita sekunge kuverenga uye kuratidza data sechikamu nderimwe remabasa akareruka atinoita neExcel. Asi vashandisi vane ruzivo vanoziva kuti basa iri harisi nyore nguva dzose.
1. Isa chiratidziro kunhamba yaunoda yenzvimbo dzedesimali
apo Percent Format inoshandiswa kunhamba, Excel 2010 uye 2013 inoratidza kukosha kwavo kwakatenderedzwa kune nhamba yakazara, uye mune dzimwe nguva izvi zvinogona kutsausa. Semuyenzaniso, isa chiyero chefomati kune isina chinhu sero uye isa kukosha kwe0,2% muchitokisi. Chii chakaitika? Ndinoona 0% mutafura yangu, kunyangwe ndichinyatsoziva kuti inofanira kunge iri 0,2%.
Kuti uone kukosha chaiko uye kwete kukosha kwekutenderera, unofanirwa kuwedzera huwandu hwenzvimbo dzinofanirwa kuratidzwa neExcel. Nokuda kweizvi:
- Vhura bhokisi rekutaura Fomati Masero (Mafomati masero) uchishandisa menyu yezviri mukati, kana kudzvanya mubatanidzwa wekiyi Ctrl + 1.
- Sarudza chikamu chikamu muzana (Percentage) uye isa nhamba yenzvimbo dzedesimali dzinoratidzwa muchitokisi sezvaunoda.
- Kana zvese zvagadzirwa, tinya OKnokuti kuchinja kunoshanda.
2. Simbisa Negative Values neFomati
Kana iwe uchida kuti hunhu husina kunaka huratidzwe zvakasiyana, senge mutsvuku font, unogona kuseta iyo tsika nhamba fomati. Vhurazve dialog Fomati Masero (Format masero) uye enda kune tab nhamba (Nhamba). Sarudza chikamu tsika (All Formats) uye pinda mumunda mhando mumwe wemitsetse inotevera:
- 00%;[Red]-0.00% or 00%;[Red]-0,00% - ratidza yakashata muzana muzana mutsvuku uye ratidza 2 decimal nzvimbo.
- 0%;[Red]-0% or 0%; [Krakurara]-0% - ratidza yakashata muzana muzana mutsvuku uye usaratidze kukosha mushure meiyo decimal point.
Unogona kudzidza zvakawanda nezve iyi nzira yekufometa mureferensi yeMicrosoft, mumusoro wekuratidza manhamba muhuwandu hwefomati.
3. Fomati Negative Percentage Values muExcel ine Conditional Formatting
Kuenzaniswa neyakapfuura nzira, mafomati ezvimiso muExcel inzira inochinjika inobvumidza iwe kuseta chero fomati yesero ine yakashata muzana kukosha.
Nzira iri nyore yekugadzira mutemo wekugadzirisa ndeyekuenda kune menyu Mamiriro ekugadzirisa > Simbisa mitemo yemasero > Pasi pane (Conditional Formatting> Cell Selection Mitemo> Zvishoma pane…) uye isa 0 mumunda. Fomati masero ari ZVISINI KUPFUURA (Fomati masero ari MASHOKO)
Tevere, mune yekudonhedza-pasi runyorwa, unogona kusarudza imwe yeakarongwa akajairwa sarudzo kana kudzvanya Rudzi rweMhando (Custom Format) pakupera kweiyi rondedzero uye gadzirisa ese mafomati esero sezvaunoda.
Heano mamwe maitiro ekushanda nawo Percentage format data inovhura Excel. Ndinovimba kuti ruzivo rwakawanwa kubva muchidzidzo chino ruchakuponesa kubva mumusoro usingakoshi mune ramangwana. Muzvinyorwa zvinotevera, tichanyura zvakadzika mumusoro wenyaya yezvikamu muExcel. Iwe unozodzidza kuti ndedzipi nzira dzaungashandisa kuverenga kufarira muExcel, dzidza mafomula ekuverenga shanduko yezana, muzana yehuwandu, mubereko wemukomboni, nezvimwe.
Ramba wakatarisa uye uchifara kuverenga!