Maitiro ekuverenga muzana yenhamba muExcel. Maitiro ekuverengera share muexcel

Zviito zvine maperesenti zvinowanzoitwa muMicrosoft Excel, zviri nyore uye zvinoshanda. Kuti uite izvi, purogiramu inoshandisa maitiro anokosha uye mabasa. Muchikamu chino, tichakurukura zvakadzama nzira dzose dzekutsvaga chiyero chenhamba.

Kuverengerwa kwemugove kubva kunhamba yakapihwa

Dzimwe nguva zvakakosha kuziva kuti ndeipi chikamu cheimwe nhamba mune imwe. Kuti uite izvi, shandisa fomura inotevera: Govera (%) = Nhamba 1/Nhamba 2*100%. Nhamba 1 ndiyo yekutanga, Nhamba 2 ndiyo inowanikwa chikamu chenhamba 1. Ngatifungei nezvekushanda kwemasvomhu nemuenzaniso. Fungidzira kuti unoda kuwana chikamu chenhamba 18 munhamba 42. Unoda kuita nhanho mbiri algorithm:

1. Sarudza cell isina chinhu uye nyora fomula ipapo nenhamba dzakapihwa. Chiratidzo chakaenzana chinodiwa pamberi pefomula, zvikasadaro iyo otomatiki kuverenga haizoitike.

2. Dzvanya kiyi ye "Enter", iyo sero icharatidza kukosha kwekuverenga sechikamu kana nhamba yenguva dzose.

Zvinokosha! Izvo hazvifanirwe kunyora iyo "* 100" chikamu mune fomula. Chikamu chinogona kutsanangurwa nekungopatsanura nhamba imwe neimwe.

Kana mhedzisiro iri nhamba, kwete muzana, iwe unofanirwa kushandura fomati yemasero. Izvi zvinogona kuitwa uchishandisa chikamu chakakodzera muExcel zvishandiso.

1. Dzvanya pasero nebhatani rekurudyi rembeva. Menyu ichavhura paunoda kusarudza chinhu che "Format Cells".

Iwe unogona zvakare kuwana iyi sarudzo paKumba tebhu. Ikoko inowanikwa muchikamu che "Masero" (chikamu "Format").

2. Menyu ine sarudzo dzekushandura fomati ichaonekwa pachiratidziri. Mu "Nhamba" tab pane urongwa hwehuwandu hwehuwandu - unoda kusarudza "Percentage". Nekumisikidza, 2 decimal nzvimbo dzakaiswa, asi izvi zvinogona kugadziriswa nemabhatani emiseve. Mushure mekupedza zvigadziriso, tinya "OK". Iye zvino sero rakasarudzwa rinogara riine data muhuwandu hwefomati.

Ngatishandisei ruzivo rwakawanwa pamuenzaniso wakaoma kunzwisisa. Semuenzaniso, iwe unofanirwa kuona chikamu chemhando yega yega yechigadzirwa mumari yakazara. Kuti tiite basa iri, tichagadzira tafura yatinoratidza mutengo weyuniti yezvigadzirwa zvakati wandei, mavhoriyamu ekutengesa uye mari. Iwe zvakare unofanirwa kuverenga iyo yakazara mari uchishandisa iyo SUM basa. Pakupera kwetafura, isu tichagadzira koramu yezvikamu mumari yakazara nemaseru muhuwandu hwefomati. Izvo zvinodikanwa kuti utarise kuverenga kwechiratidzo ichi nhanho nhanho:

1. Sarudza yekutanga yemahara sero mukoramu yekupedzisira uye isa iyo yekuverengera yekuverenga formula mumunda. Nhamba ye1 ichava mari kubva pakutengeswa kwechimwe chigadzirwa, uye chechipiri - chiyero chemari yose.

2. Dzvanya kiyi ye "Enter", iyo muzana ichaonekwa muchitokisi.

Tevere, iwe unofanirwa kuzadza iyo column yese nedata rakadaro. Izvo hazvifanirwe kuisa fomula pamurume nguva dzese - isu tinogadzirisa kuzadza nekumwe kugadziridzwa kwekutaura.

1. Chimwe chikamu cheformula chinoshanduka kubva mumutsara kuenda kumutsara, chimwe chinoramba chakafanana. Ngative nechokwadi chekuti kana basa racho raendeswa kune imwe sero, nharo imwe chete inotsiviwa. Iwe unofanirwa kudzvanya pane yakazadzwa sero uye woisa zviratidzo zvemadhora pamberi petsamba uye nhamba mukududzwa kweiyo yakazara mari munda kuburikidza neformula bar. Izwi rinofanira kutaridzika seizvi: =D2 / $D$ 10.
2. Tevere, sarudza maseru ese ari mukoramu kusvika kumutsara we "Total" nekubata kona yekurudyi pakona yekutanga. Mutsetse wega wega une ruzivo nezve kugovaniswa kwezvinhu mumari yese.

3. Iwe unogona kuwana mugove mumari yekupedzisira pasina kuverenga mari. Ngatishandisei basa reSUM - chirevo naro chinotsiva nharo yechipiri.
4. Ngatigadzire fomula nyowani: = Mari yerudzi rumwe rwechigadzirwa/SUM(Revenue renji kune zvese zvigadzirwa) Nekuda kwekuverenga, tinowana nhamba imwechete sepakushandisa nzira yapfuura:

Kuverengera chikamu chenhamba yakapihwa

Iko kushanda kwakasiyana - kutora chikamu chenhamba mune yakajairwa nhamba fomati - kunowanzodikanwa. Ngationei kuti tingaita sei kuverenga kwakadaro. Iyo calculation formula ndeye: Nhamba 2 = Muzana (%) * Nhamba 1. Zvinorehwa nechirevo ichi: chikamu chinotarwa kubva paNhamba 1, zvichikonzera Nhamba 2. Ngatiedzei fomula pamuenzaniso chaiwo. Izvo zvinodiwa kuti uzive kuti yakawanda sei - 23% ye739.

1. Isu tinosarudza sero yemahara uye tinogadzira fomura mairi ine inozivikanwa data.

2. Dzvanya "Enter", mhedzisiro yekuverenga inoonekwa pane pepa.

Teerera! Muchiitiko ichi, haufanire kushandura sero fomati nekuti unoda nhamba, kwete muzana.

Kune muenzaniso wedata, unogona kushandisa tafura yakatogadzirwa. Fungidzira kuti mwedzi unouya unoronga kutengesa 15% mamwe mayuniti ega ega chigadzirwa. Izvo zvinodikanwa kuti uone kuti ndeapi huwandu hwekugadzirwa kwemhando dzakasiyana dzezvigadzirwa zvinoenderana ne15%.

1. Isu tinogadzira chinyorwa chitsva uye tinoisa fomula inoenderana neiyo inozivikanwa data mune yekutanga sero sero.

2. Dzvanya kiyi ye "Enter" uye uwane mhedzisiro.
3. Isu tinoendesa fomu kumasero ese ekoramu tichishandisa mubato wekuzadza.

Iwe unogona kubvisa nzvimbo dzedesimali nekuchinja sero fomati. Sarudza maseru ese ane mhedzisiro, vhura iyo fomati menyu uye sarudza Numeric. Iwe unofanirwa kudzikisa huwandu hwenzvimbo dzedesimali kusvika zero uye tinya "OK", mushure meizvozvo iyo column ichange iine nhamba chete.

Kuwedzera uye kubvisa kufarira

Zvichienderana nemafomula ari pamusoro, unogona kuita masvomhu akareruka nemaperesenti.

Kuverengerwa kwenhamba yenhamba uye chiyero chayo ndeiyi inotevera: Amount=Nhamba+(Percentage (%)*Nhamba). Musiyano fomula inosiyana chete muchiratidzo: Musiyano=Nhamba-(Percentage (%)*Nhamba).

Funga nezvezviito izvi nemienzaniso - wedzera 530% kusvika 31, wobva wabvisa chikamu chimwe chete kubva panhamba yekutanga. Iwe unofanirwa kusarudza sero yemahara uye isa fomula, wobva wadzvanya "Enter".

Zvishandiso zveExcel zvinokutendera kuti uverenge mutsauko pakati penhamba mbiri dzinoratidzwa sechikamu. Formula yechiito ichi ndeiyi: Musiyano=(Nhamba 2-Nhamba 1)/Chiverengo 1*100%. 

Isu tinoshandisa fomula mumuenzaniso: kutengesa kwezvinhu kwakawedzera, uye isu tinoda kuona kuti ndeapi muzana mamwe mayuniti ezvigadzirwa zvemazita akasiyana akatengeswa.

1. Muchikamu chakanyatsogadzirwa, sarudza sero yepamusoro uye nyora fomula mairi. Nhamba 1 uye 2 ndeyekare uye itsva kutengesa.

2. Dzvanya "Enter" uye uwane mhinduro yekutanga.
3. Sarudza maseru ese ekoramu ane autocomplete marker - fomula inokopwa neyakagadziriswa.

mhedziso

Kushanda nezvikamu muExcel zviri nyore, nekuti mafomula akafanana nezviito zvinozivikanwa nevakawanda kubva kukosi yemasvomhu. Nekudaro, zvakanyanya nyore kuverenga kufarira muchirongwa, nekuti zvinokwanisika kuita otomatiki kuverenga.