- Ikuvumela ukuthi uguqule amanani phakathi kwezinhlelo ezahlukene zesisindo, ibanga, izinga lokushisa, ivolumu nokuningi.
- Kudinga ukuthi amayunithi omthombo kanye nendawo okuyo abhalwe ngamamaki okucaphuna.
- Isekela iziqalo ze-metric kanye ne-binary ukuze iphathe izikali zobukhulu obukhulu kakhulu.
- Kubalulekile ukuthi womabili amayunithi abe ngamalungu eqembu elifanayo ukuze kugwenywe iphutha le-#N/A.
Wake waba nesizindalwazi esigcwele izilinganiso ngamasentimitha futhi kwadingeka ukuthi uziguqule zibe amasentimitha ngaphandle kokuhlanya nge-calculator? Nokho, i-Excel inecebo elikhethekile elibizwa ngokuthi umsebenzi we-CONVERT , osindisa impilo uma usebenza ngedatha exubile evela ezinhlelweni ezahlukene zokulinganisa futhi udinga ukuhlela ispredishithi sakho.
Kungakhathaliseki ukuthi ungunjiniyela, umlawuli, noma umuntu ofuna nje ukuhlela izindleko zakhe ngezimali ezahlukene noma ama-peso, ukwazi ukuthi ungayisebenzisa kanjani le fomula kuzokuvumela ukuthi ulinganisele ulwazi ngokuzenzakalelayo futhi ngaphandle kwamaphutha enziwe ngesandla, okuzokongela isikhathi esiningi futhi kugweme lawo makhanda avamile abangelwa ukuguqulwa okwenziwa kabi.
Iyini ngempela umsebenzi we-CONVERT futhi usetshenziselwani?
Ngokuyisisekelo, umsebenzi oklanyelwe ukuguqula inani lezinombolo kusuka kuyunithi eyodwa yokulinganisa liye kwenye. Ilungele labo abaphatha izinqolobane zomhlaba wonke noma idatha yobuchwepheshe lapho, isibonelo, kusetshenziswa amamayela namakhilomitha. Esikhundleni sokufuna isici sokuguqulwa ku-Google nokuphindaphinda iseli ngeseli, uvumela i-Excel ukuthi ikwenzele umsebenzi.
I-Anatomy yefomula: I-syntax
Ukuze uvimbele umsebenzi ukuthi ungalethi iphutha, kumele ulandele isakhiwo esithile kakhulu. I-syntax ilandelayo: CONVERTIR(número; de_unidad; a_unidad).
- Inombolo: Lena inombolo ofuna ukuyishintsha. Kungaba inani elibhalwe ngesandla noma, ngokuvamile, ireferensi yeseli.
- Iyunithi_engaphelele: Lapha ukhomba iyunithi yokuqala yenombolo. Kubalulekile ukuyibhala. kuma-quotation marks.
- Iyunithi_e-A: Yiyunithi ofuna ukuyifinyelela, futhi ebhalwe ngamamaki okucaphuna.
Ikhathalogi ephelele yamayunithi ahambisanayo
Isici esinamandla kakhulu saleli thuluzi inani lezinhlelo elizisekelayo. Nasi incazelo eningiliziwe yalokho ongakuguqula:
Isisindo kanye nesisindo
Ungahamba phakathi kwezinhlelo ze-metric kanye ne-imperial. Yamukela igremu ( "g" ), isisindo sephawundi ( "lbm" ), i-ounce ( "ozm" ), okusanhlamvu ( "grain" ), itshe ( "stone" ), i-tonne ( "t" ), kanye ne-US ( "cwt" noma "shweight" ) kanye ne-British ( "uk_cwt" noma "lcwt" ).
Ibanga Nobude
Kusukela ku-microscopic kuya ku-astronomical. Unemitha ( "m" ), imayela ( "mi" ), imayela lolwandle ( "Nmi" ), i-inch ( "pda" ), unyawo ( "ft" ), kanye neyadi ( "yd" ). Uma uthola ubuchwepheshe obuningi, kufaka phakathi i-Angstrom ( "ang" ), unyaka wokukhanya ( "al" ), kanye ne-parsec ( "pc" ), kanye namayunithi amadala njenge-ell ( "ell" ) noma i-pica ( "pica" ).
Isikhathi, Ukucindezeleka, Namandla
Ngesikhathi, yamukela iminyaka ( "unyaka" ), izinsuku ( "usuku" ), amahora ( "ihora" ), imizuzu ( "mn" ), kanye nemizuzwana ( "isekhondi" ). Ukuze uthole ingcindezi, ungasebenzisa ama-Pascal ( "Pa" ), ama-atmospheres ( "atm" ), noma ama-PSI ( "psi" ). Ukuze uthole amandla, izinketho yi-Newtons ( "N" ), ama-dynes ( "dyn" ), noma ama-pounds-force ( "lbf" ).
Amandla, Amandla kanye ne-Magneticism
Ngamandla, ungaguqula ube yi-Joules ( "J" ), ama-calories ( "cal" ), ama-Watt-hours ( "Wh" ), noma ama-BTU ( "BTU" ). Ngamandla, unamandla ehhashi ( "hp" ) kanye nama-watts ( "W" ). I-Magnetic iphathwa ngama-Tesla ( "T" ) kanye nama-Gausses ( "ga" ).
Izinga Lokushisa Nomthamo
Kuwusizo kakhulu ekuguquleni kusuka ku-Celsius ( "C" ) kuya ku-Fahrenheit ( "F" ) noma ku-Kelvin ( "K" ). Ngokuphathelene nomthamo, unamayunithi asukela ku-teaspoon ( "tsp" ) kanye ne-cup ( "cup" ) kuya ku-gallon ( "gal" ), ilitha ( "l" ), kanye ne-cubic meter ( "m³" ), kufaka phakathi i-barrel kawoyela ( "barrel" ).
Indawo kanye nolwazi
Isekela amahektha ( "ha" ), amamitha-skwele ( "m2" ), amahektha ( "us_acre" ), kanye namamayela-skwele ( "mi2" ). Kososayensi bekhompyutha, ivumela ukuguqulwa kusuka kuma-bit ( "bit" ) kuya kuma-byte ( "byte" ).
Iziqalo ze-metric neze-binary
Uma udinga ukusebenza ngezikali ezinkulu noma ezincane, i-Excel ikuvumela ukuthi wengeze iziqalo kumayunithi e-metric. Isibonelo, ungasebenzisa u- "k" kumakhilo (10^3), u- "M" kuma-mega (10^6), noma u-"m" kuma-milli (10^-3). Kukhona futhi iziqalo ezimbili zokugcina idatha, njenge- "Ki" (kibi) noma i- "Mi" (mebi) , ezisekela izibalo zazo emandleni angu-2 (2^10, 2^20, njll.).
Amaphutha angenzeka nokuthi ungawagwema kanjani
Ngezinye izikhathi ifomula ayisebenzi futhi ibuyisa amaphutha. Lokhu kuvame ukwenzeka ngezizathu ezintathu: inani le-#VALUE! liyavela uma idatha yokufaka ingeyona inombolo; iphutha le- #N/A livela uma iyunithi ingekho, uma isiqalo singalungile, noma uma uzama ukuguqula izinto ezingenangqondo ndawonye (njengokuguqula amakhilogremu abe amamitha). Khumbula ukuthi i-Excel ikhethekile ngezinhlamvu ezinkulu nezincane kumagama amayunithi.
Umhlahlandlela osebenzayo: Imiyalelo yesinyathelo ngesinyathelo yokusebenzisa ukuguqulwa
Ake sithi unohlu lwamabanga ngamakhilomitha futhi ufuna amamitha. Inqubo ilula kakhulu:
- Chofoza kuseli lapho ufuna khona umphumela bese uthayipha
=CONVERTIR(. - Empikiswaneni yokuqala, khetha iseli eliqukethe inombolo (isibonelo, D4).
- Empikiswaneni yesibili, bhala iyunithi yomthombo ngamamaki okucaphuna: "km".
- Empikiswaneni yesithathu, beka iyunithi yendawo oya kuyo: «M».
- Vala ama-parenthesis bese ucindezela u-Enter. Manje kufanele nje hudula ifomula phansi ukuguqula lonke ikholomu.
Amathiphu engeziwe okuhlanza idatha yakho
Uma, uma uzama ukusebenzisa i-CONVERT, ubona ukuthi izinombolo zakho zigcinwe njengombhalo, ifomula izohluleka. Ukuze ulungise lokhu, ungasebenzisa i- Umsebenzi we-VALUELokhu kukhipha ingxenye yezinombolo yomucu wombhalo. Udinga nje ukudala ikholomu eyisizayo, bese uyisebenzisa =VALOR(celda) bese namathisela imiphumela njengenani kukholamu yokuqala ukuze kuhlanzwe isizindalwazi.
Ukwazi kahle la mathuluzi okuguqula nokuhlanza kukuvumela ukuthi uphathe amavolumu edatha ayinkimbinkimbi ngokunemba okuphelele, uqede isidingo sokubala ngesandla okukhathazayo nokuqinisekisa ukuthi lonke ulwazi lwakho luyahambisana kungakhathaliseki ukuthi uhlelo lokulinganisa lokuqala lunjani.