Nzira yekuisa sei decimals muExcel? Muchidzidzo ichi tinokusiira iwe ese matanho uye mamwe madhata.
Chokwadi, pari zvino iwe unofanirwa kuziva kuti Excel ndechimwe chezvishandiso zvakabudirira kwazvo pasi rose kuronga, kupatsanura uye kugadzira maspredishiti, kwete chete nekuti ine nhamba inoshamisa yemabasa. Asi nekuti mukati mayo, tinogona kuita chero mhando yebasa nemapurojekiti, pasina chikonzero chekuve nyanzvi mukati meiyo interface.
Zvakare, iwe unofanirwa kuziva kuti mukati mechirongwa chimwe chete tinogona kuita mashandiro echisimari, ayo anobatsira kwazvo kuminda yeaccounting uye manejimendi, ingave yebasa, bhizinesi kana kungoita sebasa reyunivhesiti. MuExcel tinogona kuisa decimals, Pasina kushanda nesimba.
Zvino, kana iwe ukangozviwana wava kuziva uye kudzidza nezve inoshamisa mabhenefiti eExcel, mukuwedzera kune ese mabasa ayo anayo, isu tichaita kuti basa rive nyore kwauri. ndichikudzidzisai sei kuisa decimals muExcel, sokunge uri nyanzvi.
Nzira dzekuisa ma decimals muExcel
Mune izvo tinofanira kukuudza, kuti kune nzira dzakasiyana, dzatinogona nadzo wedzera nhamba dzedesimali kune peji reExcel, idzo nzira dzakafanana, tinodzitsanangura nedanho nedanho. Izvo zvinotevera:
Isa fomura mumutsara unoenderana
Iyi ndiyo nzira yekutanga, yatichakudzidzisa kuti ugone isa decimals muexcel sheet, nokuda kweizvi unofanira kutevera mirairo yatinokusiira iwe zvino. Ndiwo anotevera:
- Senhanho yekutanga, iwe uchafanirwa kuvhura Excel spreadsheet.
- Ipapo iwe unofanirwa kuisa kukosha kwenhamba dzakatenderedzwa, imwe neimwe mukati mesero rega. Sekurudziro, zviri nani kuisa manhamba, ese mukati mechikamu chimwe chete, izvo zvichaita kuti nzira ive nyore kuita.
- Mukati mechikamu chechipiri, iwe unofanirwa kuwedzera inotevera fomula "= kutenderera (A1,N)". Panguva iyoyo, unofanira kutsiva "N" mukati mefomula nenhamba yedesimali, yaunoda kuwedzera.
- Pamakoramu anotevera, hazvizove zvakakosha kunyora zvakare fomula, nekuti iwe unogona kudhonza nekuidonhedza mumaseru anotevera, kusvika kune yekupedzisira yaunoda kushandisa. Iwe unogona zvakare kushandisa iyo yekukopa uye yekuisa sarudzo, kana dziri mukoramu imwechete.
- Muenzaniso: “=Kutenderera (A1,8)”
Ndizvo! Nenzira iyoyo unenge wadzidza nzira yekutanga yekuisa decimals muExcel.
Isa decimals muExcel pasina fomula
Iyi ndiyo Imwe nzira inozivikanwa isa ma decimals muExcel, kune rumwe rutivi, izvi hazvidi mafomula kuti akwanise kushanda uye nekuda kweizvi, tinokusiirawo runyoro rwakakwana rwematanho, ari seanotevera:
- Kutanga isa iyo decimal manhamba kukosha iwe yaunoda, musero rega rega.
- Ipapo iwe unofanirwa kusarudza imwe kana yese.
- Tevere iwe uchafanirwa kuzviwana mukati me "kutanga" tab.
- Zvadaro, unofanira kushandisa mabhatani "kuderedza kana kuwedzera" nhamba yemasero akasarudzwa nedhijiti imwe. Nenzira iyoyo inenge yakagadzirira.
Saizvozvowo, unogona kuva nazvo isa decimals muexcel usingashandisi fomula.
Isa ma decimals muExcel uchishandisa Truncate basa, remadecimals asina kutenderera
Tinofanira kureurura kuti nzira dzakapfuura dzinobva chete panzira yakajairika, iyo inotibvumira kuwedzera kana kuderedza nhamba, zvichienderana nekuti iyo decimal iri pamusoro kana pasi pe5.
Munzira iyi, nhamba dzasara dzedesimali dzichabviswa otomatiki, zvisinei nekutenderedza kwacho, nekuda kweizvi tine matanho anotevera:
- Mukati mesero isina chinhu, tinofanirwa kunyora fomura inotevera: “=TRUNCAR(A1;N)» tichifungidzira kuti bhokisi A! ndipo pane nhamba yedesimali uye "N" inhamba yemanhamba yatinoda kuona muspredishiti.
- Ipapo isu tinofanirwa kungodzvanya "enter" kiyi uye nenzira iyoyo tinopedza.
Ndizvozvo, saka tine imwe sei kuisa decimals muExcel.
Round decimals muExcel. (Pfungwa dzakakosha dzekufunga)
Unofanira kuziva kuti isa decimal muExcel, harisi basa rakaoma kana rakaoma, ikozvino kutenderedza aya madesimali, unogona kushandisa ese nzira dzatakakusiira nadzo kare. Iwo mamwewo aunogona kushandisa, kana kushomeka kwema decimals harisi dambudziko kwauri.
Zvakare, iwe unofanirwa kuziva kuti mabasa ekutenderedza decimals mukati meExcel anonyanya kutongwa nemumwe mutemo, umo tinoudzwa kuti kana nhamba yekupedzisira yenhamba yedesimali yakakura kupfuura 5, nhamba inowedzera. a 1. Kune rimwe divi. ruoko, kana nhamba imwe chete iyoyo ichipera mudesimali ine kukosha isingasviki 5, ipapo nhamba yehwaro inosara, neukoshi hwayo hwazvino.
Mamwe maapplication anotitendera kuti tiite mashandiro nemadecimals
In incredible case iyoyo Excel inogona kunge isiri iyo chirongwa chawanga uchitsvaga chaizvo kuti uite yako yekuverenga mashandiro nemadecimals, tinokusiira dzimwe nzira, dzaunogona kushandisa panguva ino, kuti ugone kuisa madecimals. Izvi ndizvo zvinotevera:
1. Symbolab
Iyi karukureta yepamhepo, kwatinokwanisa kuita marudzi ese e algebraic mashandiro, kubva pane akareruka kusvika kune akaomarara.
Iyi Calculator inogona kushandiswa kana ichisvika pawebhu papuratifomu https://es.symbolab.com/solver/decimals-calculator, ndezvemahara uye unogona kuwana akawanda anoshamisa maficha.
Pamusoro pekuti inonyatso batsira, kana uchiita chero kuwedzera, kubvisa, kuwanda kana kupatsanurwa kwedecimals, pasina chikonzero chekunyora pasi kana kuchengetedza data, kune chimwe chinhu chenguva.
2. DivPad: Math Danho neNhanho
Ichi, kune chikamu chayo, chishandiso chinowanikwa cheiyo Android inoshanda sisitimu, kwaunogona kuita marudzi ese emasvomhu mashandiro, kusanganisira decimal mashandiro, mune imwe nyaya yemaminetsi.
Kana iwe uchida kuverenga kana kuwana account, nenzira kwayo uye nekukurumidza, iyi mobile application ndiyo yaunofanira kushandisa.
3. Diviation Calculator (nezvasara kana decimals)
Iyi, kune rimwe divi, zvakare iri application yeiyo Android inoshanda sisitimu, iyo yakasununguka zvachose uye inopindirana, ine hunhu hwega hwekuti inotarisa zvakajeka pakugadzirisa mashandiro nemadecimals.
Saka kana iwe uchigara uchiverenga uchishandisa decimals, iyi application ndiyo yaunofanirwa kusarudza.