Momwe mungawerengere logarithm mu Excel. LOG ntchito yowerengera logarithm mu Excel

Microsoft Excel ili ndi ntchito zambiri zomwe zimakupatsani mwayi wowerengera masamu mwachangu. Chimodzi mwazodziwika komanso chodziwika bwino ndi LOG, chomwe chingagwiritsidwe ntchito kuwerengera ma logarithm. Nkhaniyi ifotokoza mfundo ya kagwiritsidwe ntchito kake komanso mawonekedwe ake.

Momwe mungawerengere logarithm mu Excel

LOG imakulolani kuti muwerenge logarithm ya nambala ku maziko otchulidwa. Kawirikawiri, ndondomeko ya logarithm mu Excel, mosasamala kanthu za pulogalamuyo, imalembedwa motere: =LOG(nambala;[base]). Pali zifukwa ziwiri mu fomula yomwe yaperekedwa:

• Nambala. Uwu ndi nambala yomwe wogwiritsa ntchito alowetsamo momwe logarithm iyenera kuwerengedwera. Nambalayo ikhoza kulowetsedwa pamanja pagawo lolowetsa fomula, kapena mutha kuloza cholozera cha mbewa ku cell yomwe mukufuna ndi mtengo wolembedwa.
• Base. Ichi ndi chimodzi mwa zigawo za logarithm zomwe zimawerengedwa. Maziko amathanso kulembedwa ngati nambala.

Tcherani khutu! Ngati maziko a logarithm sanadzazidwe mu Excel, pulogalamuyo imangoyika mtengo wake kukhala zero.

Momwe mungawerengere decimal logarithm mu Microsoft Excel

Kuti muwerenge mosavuta, Excel ili ndi ntchito ina yomwe imawerengera ma logarithms okha - iyi ndi LOG10. Fomulayi imayika maziko kukhala 10. Mukasankha ntchito ya LOG10, wogwiritsa ntchito adzangofunika kulowetsa nambala yomwe logarithm idzawerengedwe, ndipo mazikowo amasinthidwa kukhala 10. Fomula yolembera ikuwoneka motere: =LOG10 (nambala).

Momwe mungagwiritsire ntchito ntchito ya logarithmic mu Excel

Mosasamala mtundu wa pulogalamu yomwe idayikidwa pakompyuta, kuwerengera kwa logarithms kumagawidwa m'magawo angapo:

• Yambitsani Excel ndikupanga tebulo laling'ono la magawo awiri.
• Lembani manambala asanu ndi awiri aliwonse mugawo loyamba. Nambala yawo imasankhidwa mwakufuna kwa wogwiritsa ntchito. Mzere wachiwiri uwonetsa zikhalidwe za ma logarithms a manambala.

• Dinani LMB pa nambala yomwe ili mgawo loyamba kuti musankhe.
• Pezani chithunzi cha masamu kumanzere kwa kapamwamba kapamwamba ndikudina pamenepo. Izi zikutanthauza "Ikani Ntchito".

• Pambuyo poyeserera koyambirira, zenera la "Insert function" lidzawonetsedwa. Apa muyenera kukulitsa ndime ya "Category" podina muvi womwe uli kumanja, sankhani njira ya "Math" pamndandanda ndikudina "Chabwino".
• Pamndandanda wa ogwiritsa ntchito omwe atsegulidwa, dinani pamzere wa "LOG", kenako dinani "Chabwino" kuti mutsimikizire zomwe zachitika. Zosintha za fomula ya logarithmic ziyenera kuwonetsedwa.

• Tchulani deta yowerengera. M'gawo la "Nambala", muyenera kulemba nambala yomwe logarithm idzawerengedwera podina pa selo lofananira pa tebulo lopangidwa, ndi mzere wa "Base", pamenepa, muyenera kulowa. nambala 3.

• Press "Lowani" kapena "Chabwino" pansi pa zenera ndi kuona zotsatira. Ngati zochitazo zachitidwa molondola, ndiye kuti zotsatira za kuwerengera logarithm zidzawonetsedwa mu selo losankhidwa kale la tebulo. Ngati mudina pa nambalayi, ndiye kuti mzere wowerengera udzawonekera pamzere pamwambapa.

• Chitani ntchito yomweyo ndi manambala otsala patebulo kuti muwerengere logarithm yawo.

Zina Zowonjezera! Mu Excel, sikofunikira kuwerengera pamanja logarithm ya nambala iliyonse. Kuti muchepetse kuwerengera ndikusunga nthawi, muyenera kusuntha cholozera cha mbewa pamtanda pakona yakumanja kwa selo ndi mtengo wowerengeka, gwirani LMB ndikukokera fomulo ku mizere yotsala ya tebulo kuti mudzaze. zokha. Komanso, nambala yomwe mukufuna idzalembedwera nambala iliyonse.

Kugwiritsa ntchito mawu a LOG10 mu Excel

Kutengera chitsanzo chomwe takambirana pamwambapa, mutha kuphunzira momwe ntchito ya LOG10 ikuyendera. Kuti ntchitoyi ikhale yosavuta, tiyeni tisiye tebulo ndi manambala omwewo, titachotsa ma logarithm omwe adawerengedwa kale mugawo lachiwiri. Mfundo yogwiritsira ntchito LOG10 ikhoza kufotokozedwa motere:

• Sankhani selo loyamba mugawo lachiwiri la tebulo ndikudina batani la "Insert function" kumanzere kwa mzere kuti mulowetse mafomu.
• Malinga ndi chiwembu chomwe takambirana pamwambapa, onetsani gulu la "Mathematics", sankhani "LOG10" ndikudina "Lowani" kapena dinani "Chabwino" pansi pazenera la "Ikani ntchito".
• Mu "Function Arguments" menyu yomwe imatsegulidwa, muyenera kuyika nambala yokhayo, malinga ndi zomwe logarithm idzachitike. M'gawoli, muyenera kufotokoza za foni yomwe ili ndi nambala yomwe ili pagawo loyambira.

• Dinani "Chabwino" kapena "Lowani" ndikuwona zotsatira. Mugawo lachiwiri, logarithm ya nambala yotchulidwa iyenera kuwerengedwa.
• Mofananamo, tambasulani mtengo wowerengedwa ku mizere yotsala mu tebulo.

Zofunika! Mukakhazikitsa ma logarithmu mu Excel, m'munda wa "Nambala", mutha kulemba pamanja manambala omwe mukufuna patebulo.

Njira ina yowerengera ma Logarithms mu Excel

Microsoft Office Excel ili ndi njira yosavuta yowerengera ma logarithm a manambala ena. Zimathandiza kusunga nthawi yofunikira kuti achite masamu. Njira yowerengerayi yagawidwa m'njira zotsatirazi:

• Mu cell yaulere ya pulogalamuyo, lembani nambala 100. Mutha kufotokozera mtengo wina uliwonse, zilibe kanthu.
• Sankhani selo lina laulere ndi cholozera cha mbewa.
• Pitani ku bar ya formula pamwamba pa menyu yayikulu.
• Lembani ndondomeko “=LOG(nambala; [base])” ndikudina “Enter”. Mu chitsanzo ichi, mutatha kutsegula bulaketi, sankhani ndi mbewa selo yomwe nambala 100 inalembedwa, kenaka ikani semicolon ndikuwonetsa maziko, mwachitsanzo 10. Kenaka, tsekani bulaketi ndikudina "Lowani" kuti mutsirize. fomula. Mtengowo udzawerengedwa zokha.

Tcherani khutu! Kuwerengera mwachangu kwa decimal logarithms kumachitika chimodzimodzi pogwiritsa ntchito LOG10.

Kutsiliza

Chifukwa chake, mu Excel, ma algorithms amawerengedwa pogwiritsa ntchito ntchito za "LOG" ndi "LOG10" munthawi yaifupi kwambiri. Njira zowerengera zidafotokozedwa mwatsatanetsatane pamwambapa, kuti wogwiritsa ntchito aliyense azitha kusankha yekha njira yabwino kwambiri.