Ungabala kanjani i-logarithm ku-Excel. Umsebenzi we-LOG wokubala i-logarithm ku-Excel

I-Microsoft Excel inenani elikhulu lemisebenzi ekuvumela ukuthi wenze izibalo zezibalo ngokushesha. Omunye wemisebenzi ejwayeleke kakhulu futhi edumile i-LOG, engasetshenziswa ukubala ama-logarithms. Lesi sihloko sizoxoxa ngesimiso sokusebenza kwayo kanye nezici zesici.

Ungabala kanjani i-logarithm ku-Excel

I-LOG ikuvumela ukuthi ufunde i-logarithm yenombolo kusisekelo esishiwo. Ngokuvamile, ifomula ye-logarithm ku-Excel, kungakhathaliseki ukuthi inguqulo yohlelo, ibhalwe kanje: =UKWAZI NGATHI(inombolo;[isisekelo]). Kunezimpikiswano ezimbili kufomula ethulwayo:

• Inombolo. Leli inani lenombolo elifakwe umsebenzisi okuzobalwa kulo i-logarithm. Inombolo ingafakwa mathupha kunkambu yokufaka yefomula, noma ungakhomba ikhesa yegundane kuseli oyifunayo ngenani elibhaliwe.
• Isisekelo. Lena enye yezingxenye ze-logarithm ebalwa ngayo. Isisekelo singabuye sibhalwe njengenombolo.

Nakani! Uma isisekelo se-logarithm singagcwaliswanga ku-Excel, uhlelo luzosetha ngokuzenzakalelayo inani libe uziro.

Ungabala kanjani i-logarithm yedesimali ku-Microsoft Excel

Ukuze kube lula ukubala, i-Excel inomsebenzi ohlukile obala amalogarithmu edesimali kuphela - lena ithi LOG10. Le fomula isetha isisekelo sibe ngu-10. Ngemva kokukhetha umsebenzi we-LOG10, umsebenzisi uzodinga kuphela ukuthi afake inombolo okuzobalwa ngayo i-logarithm, futhi isisekelo sisethwa ngokuzenzakalelayo sibe ngu-10. Ukufakwa kwefomula kubukeka kanje: =UKWAZI NGATHI10(inombolo).

Ungawusebenzisa kanjani umsebenzi we-logarithmic ku-Excel

Kungakhathalekile ukuthi iyiphi inguqulo yesoftware efakwe kukhompyutha, ukubalwa kwama-logarithms kuhlukaniswe izigaba ezimbalwa:

• Yethula i-Excel bese udala ithebula elincane elinamakholomu amabili.
• Bhala noma yiziphi izinombolo eziyisikhombisa kukholamu yokuqala. Inombolo yabo ikhethwa ngokubona komsebenzisi. Ikholomu yesibili izobonisa amanani ama-logarithm amanani ezinombolo.

• Chofoza i-LMB enombolweni ekukholomu yokuqala ukuze uyikhethe.
• Thola isithonjana somsebenzi wezibalo ohlangothini lwesobunxele lwebha yefomula bese uchofoza kuso. Lesi senzo sisho “Faka Umsebenzi”.

• Ngemva kokwenza ukukhohlisa kwangaphambilini, iwindi elithi “Faka umsebenzi” lizovela. Lapha udinga ukwandisa ikholomu "Isigaba" ngokuchofoza umcibisholo ongakwesokudla, khetha inketho "yezibalo" ohlwini bese uchofoza okuthi "KULUNGILE".
• Ohlwini lwabasebenzisi oluvulayo, chofoza umugqa othi “LOG”, bese uchofoza u-“KULUNGILE” ukuze uqinisekise isenzo. Imenyu yezilungiselelo zefomula ye-logarithmic kufanele manje iboniswe.

• Cacisa idatha yesibalo. Esigabeni esithi "Inombolo", udinga ukubhala inani lenombolo lapho i-logarithm izobalwa khona ngokuchofoza iseli elihambisanayo kuthebula elidaliwe, futhi emgqeni othi "Base", kulokhu, uzodinga ukufaka inombolo 3.

• Cindezela okuthi “Enter” noma “KULUNGILE” ezansi kwewindi bese uhlola umphumela. Uma izenzo zenziwe ngendlela efanele, umphumela wokubala i-logarithm uzovezwa kuseli elikhethwe ngaphambilini lethebula. Uma uchofoza le nombolo, kuzovela ifomula yokubala kulayini ongenhla.

• Yenza umsebenzi ofanayo ngezinombolo ezisele kuthebula ukuze ubale i-logarithm yazo.

Ulwazi Olwengeziwe! Ku-Excel, akudingekile ukubala ngokwakho i-logarithm yenombolo ngayinye. Ukuze wenze izibalo zibe lula futhi wonge isikhathi, udinga ukususa isikhombi segundane phezu kwesiphambano ekhoneni elingezansi kwesokudla seseli ngenani elibaliwe, ubambe i-LMB bese uhudulela ifomula emigqeni esele yetafula ukuze igcwaliswe. ngokuzenzakalelayo. Ngaphezu kwalokho, ifomula oyifunayo izobhalwa enombolweni ngayinye.

Ukusebenzisa isitatimende se-LOG10 ku-Excel

Ngokusekelwe esibonelweni okukhulunywe ngaso ngenhla, ungafunda ukusebenza komsebenzi we-LOG10. Ukwenza umsebenzi ube lula, masishiye ithebula nezinombolo ezifanayo, ngemva kokususa ama-logarithm abalwe ngaphambilini kukholamu yesibili. Umgomo wokusebenza komsebenzisi we-LOG10 ungachazwa kanje:

• Khetha iseli yokuqala kukholamu yesibili yethebula bese uchofoza inkinobho ethi “Faka umsebenzi” kwesokunxele emugqeni ukuze ufake amafomula.
• Ngokohlelo okuxoxwe ngalo ngenhla, khombisa isigaba esithi “Mathematics”, khetha umsebenzi othi “LOG10” bese uchofoza u-“Enter” noma uchofoze okuthi “KULUNGILE” ezansi kwewindi elithi “Faka umsebenzi”.
• Kumenyu ethi "Izimpikiswano Zomsebenzi" evulayo, udinga ukufaka inani lenombolo kuphela, okuzokwenziwa ngalo i-logarithm. Kulo mkhakha, kufanele ucacise ireferensi yeseli enenombolo kuthebula lomthombo.

• Cindezela okuthi “KULUNGILE” noma “Faka” bese uhlola umphumela. Kukholomu yesibili, i-logarithm yenani lenombolo eshiwo kufanele ibalwe.
• Ngokufanayo, yelula inani elibaliwe emigqeni esele kuthebula.

Kubalulekile! Lapho usetha ama-logarithm ku-Excel, endaweni ethi “Inombolo”, ungakwazi ukubhala ngokuzenzela izinombolo ozifunayo etafuleni.

Enye indlela yokubala ama-logarithms ku-Excel

I-Microsoft Office Excel inendlela elula yokubala ama-logarithm ezinombolo ezithile. Kuyasiza ukonga isikhathi esidingekayo ukwenza umsebenzi wezibalo. Le ndlela yokubala ihlukaniswe ngezinyathelo ezilandelayo:

• Kuseli yamahhala yohlelo, bhala inombolo 100. Ungacacisa noma yiliphi elinye inani, akunandaba.
• Khetha elinye iseli lamahhala elinekhesa yegundane.
• Hambisa kubha yefomula phezulu kumenyu yohlelo oluyinhloko.
• Nikeza ifomula “=UKWAZI NGATHI(inombolo;[isisekelo])” bese ucindezela u-“Enter”. Kulesi sibonelo, ngemva kokuvula ubakaki, khetha ngegundane iseli okubhalwe kulo inombolo engu-100, bese ufaka isemicolon bese ubonisa isisekelo, isibonelo 10. Okulandelayo, vala ubakaki bese uchofoza u-“Enter” ukuze uqedele. ifomula. Inani lizobalwa ngokuzenzakalelayo.

Nakani! Ukubalwa okusheshayo kwama-logarithms wedesimali kwenziwa ngendlela efanayo kusetshenziswa u-opharetha we-LOG10.

Isiphetho

Ngakho, ku-Excel, ama-algorithms abalwa kusetshenziswa imisebenzi ethi “LOG” kanye “LOG10” ngesikhathi esifushane kakhulu. Izindlela zokubala zichazwe ngokuningiliziwe ngenhla, ukuze umsebenzisi ngamunye akwazi ukuzikhethela inketho ekhululekile kakhulu.