Maitiro ekuverenga markup muzana muExcel

MuMicrosoft Office Excel, zvinokwanisika kuverenga huwandu hwemakapu kune chimwe chigadzirwa munguva ipfupi inobvira uchishandisa yakakosha formula. Tsanangudzo yekuverenga ichapihwa mune ino chinyorwa.

Chii chinonzi markup

Kuti uverenge iyi parameter, unofanira kutanga wanzwisisa kuti chii. Markup ndiwo mutsauko uripo pakati pekutengesa nekutengesa mutengo wezvinhu, zvichikonzera kuwedzera kwemutengo wezvigadzirwa zvemutengi wekupedzisira. Saizi yemuganho inotsamira pazvinhu zvakawanda, uye inofanirwa kuvhara mari.

Teerera! Margin uye markup ipfungwa mbiri dzakasiyana uye haifanirwe kuvhiringika kune imwe neimwe. Mariji ndiyo purofiti kubva mukutengeswa kwezvinhu, iyo inowanikwa mushure mekubvisa mari inodiwa.

Maitiro ekuverengera Markup Percentage muExcel

Hapana chikonzero chekuverenga nemaoko. Izvi hazvina kufanira, nekuti. Excel inobvumidza iwe kuti uite otomatiki chero chero masvomhu chiito, kuchengetedza nguva yemushandisi. Kukurumidza kuverenga iyo markup muzana mune iyi software, unofanirwa kuita anotevera matanho:

1. Gadzira iyo yekutanga data tafura. Zviri nyore kushanda nemakoramu atopihwa mazita. Semuenzaniso, iyo column icharatidzwa mhedzisiro yeformula inogona kunzi "Markup,%". Nekudaro, iyo column musoro haikanganisi mhedzisiro yekupedzisira uye saka inogona kuve chero chinhu.
2. Isa chiratidzo che "Equals" kubva paibhodhi mune inodiwa, isina chinhu sero retafura yetafura uye isa fomula yakataurwa muchikamu chapfuura. Somuenzaniso, kupinda "(C2-A2) / A2 * 100". Mufananidzo uri pazasi unoratidza fomula yakanyorwa. Mumaparentheses mune mazita emaseru umo manyorerwo anoenderana purofiti uye mutengo wezvinhu. Muchokwadi, masero anogona kunge akasiyana.

3. Dzvanya "Enter" pakhibhodi yekombuta kuti upedze fomula.
4. Tarisa mhinduro. Mushure mekuita manipulations ari pamusoro, muchikamu chetafura pakapinzwa fomula, nhamba chaiyo inofanirwa kuratidzwa inoratidza chiratidzo chechiratidzo chechigadzirwa sechikamu.

Zvinokosha! Iyo markup inogona kuverengerwa nemaoko kuti uone kana kukosha kwemhedzisiro kwakarurama. Kana zvese zviri izvo, saka iyo yakatemerwa fomula inofanirwa kutambanudzirwa kune yakasara mitsetse yetafura yekuzadza kwavo otomatiki.

Kuti margin inoverengerwa sei muMS Excel

Kuti uwane kunzwisisa kwakakwana kwechinyorwa, zvinodikanwa kuti utarise mutemo wekuverenga margin muMicrosoft Office Excel. Pano, zvakare, hapafaniri kuva nematambudziko kunyange kune vasina ruzivo rwevashandisi vepurogiramu. Kuti uwane mhedzisiro yakabudirira, unogona kushandisa nhanho-ne-nhanho algorithm:

1. Gadzira spreadsheet kuti uverenge muganho. Mune yekutanga tafura rondedzero, unogona kuisa akati wandei ma paramita ekuverenga, kusanganisira iyo margin.
2. Isa mutsara wegonzo musero rinoenderana rendiro, isa chiratidzo "Kuenzana" uye nyora fomula inoratidzwa pamusoro. Somuenzaniso, ngatinyorei chirevo chinotevera: "(A2-C2) / C2 * 100".

3. Dzvanya "Enter" kubva pane keyboard kuti usimbise.
4. Tarisa mhinduro. Mushandisi anofanira kuve nechokwadi chekuti sero rakambosarudzwa rine kukosha kunoratidza chiratidzo chemargin. Kuti uone, iwe unogona kuverengera pachedu kukosha nezviratidzo zvakatarwa. Kana mhinduro dzakasangana, saka iyo yakatemwa fomula inogona kukwidziridzwa kune asara maseru etafura array. Muchiitiko ichi, mushandisi achazviponesa kubva pakuzadzazve chimwe nechimwe chinodiwa mutafura, achichengetedza nguva yake.

Mamwe Mashoko! Kana mushure mekunyora fomula, iyo Microsoft Office Excel software inogadzira chikanganiso, ipapo mushandisi anozoda kunyatso tarisisa kurongeka kwemavara akaiswa mukutaura.

Mushure mekuverenga iyo markup uye margin zviratidzo, unogona kuronga izvi zvakakosha patafura yekutanga kuitira kuti uone mutsauko pakati pezviviri zvinotsamira.

Nzira yekuverenga sei muzana kukosha muExcel

Kana mushandisi achida kunzwisisa kuti ndeipi nhamba yechiratidzo chakaverengerwa chinoenderana, anofanira kuita zvinotevera manipulations:

1. Mune chero sero yemahara yeExcel sheet sheet, nyora fomula "= muzana kukosha * huwandu hwese." Mamwe mashoko mumufananidzo pazasi.

2. Dzvanya "Enter" kubva paPC keyboard kuti upedze fomula.
3. Tarisa mhinduro. Panzvimbo pechimiro, nhamba chaiyo ichaonekwa musero, inova mhedzisiro yekutendeuka.

4. Iwe unogona kutambanudza fomuro kumitsara yakasara yetafura kana huwandu hwese kubva kubva muzana hunoverengwa hwakafanana nemamiriro ose.

Teerera! Kuongorora kukosha kwakaverengerwa kunoitwa nyore nemaoko uchishandisa yakajairika calculator.

Maitiro ekuverenga muzana yenhamba muExcel

Iyi ndiyo nzira yekudzokera kumashure yakurukurwa pamusoro apa. Somuenzaniso, unofanira kuverenga kuti ingani muzana nhamba 9 kubva nhamba 17. Kuti uite basa racho, unofanira kuita sezvinotevera:

1. Isa chitubu chegonzo musero risina chinhu muExcel worksheet.
2. Nyora pasi fomula "= 9/17 * 100%".

3. Dzvanya "Enter" kubva pane keyboard kuti upedze fomula uye uone mhedzisiro musero rimwe chete. Mhedzisiro yacho inofanira kuva 52,94%. Kana zvichidikanwa, nhamba yemanhamba mushure meiyo decimal point inogona kuwedzerwa.

mhedziso

Saka, chiratidzo chemuganho chechimwe chigadzirwa muMicrosoft Office Excel chinoverengerwa uchishandisa yakajairwa fomula. Chinhu chikuru ndechekunyora chirevo nenzira kwayo, zvichiratidza masero akakodzera umo manyorerwo anodiwa. Kuti unzwisise nyaya iyi zvakanaka, unofanira kunyatsoverenga mashoko ari pamusoro apa.