Yadda ake lissafin logarithm a cikin Excel. Ayyukan LOG don ƙididdige logarithm a cikin Excel

Microsoft Excel yana da ayyuka masu yawa waɗanda ke ba ku damar yin lissafin lissafi cikin sauri. Ɗaya daga cikin ayyukan gama gari kuma sananne shine LOG, wanda za'a iya amfani dashi don lissafin logarithms. Wannan labarin zai tattauna ka'idar aikinsa da halayen halayensa.

Yadda ake lissafin logarithm a cikin Excel

LOG yana ba ku damar karanta logarithm na lamba zuwa ƙayyadadden tushe. Gabaɗaya, dabarar logarithm a cikin Excel, ba tare da la’akari da sigar shirin ba, an rubuta kamar haka: =shiga(lamba; [bas]). Akwai dalilai guda biyu a cikin dabarar da aka gabatar:

• Lamba. Wannan ita ce ƙimar lambobi da mai amfani ya shigar wanda daga ita za a ƙididdige logarithm. Ana iya shigar da lambar da hannu a filin shigar da dabara, ko kuma za ku iya nuna siginan linzamin kwamfuta zuwa tantanin da ake so tare da rubutaccen ƙimar.
• Tushen. Wannan yana daya daga cikin abubuwan logarithm da ake lissafta shi. Hakanan za'a iya rubuta tushe azaman lamba.

Kula! Idan tushen logarithm bai cika a cikin Excel ba, shirin zai saita ƙimar ta atomatik zuwa sifili.

Yadda ake lissafin logarithm decimal a Microsoft Excel

Don sauƙi na lissafi, Excel yana da aikin daban wanda ke ƙididdige logarithms na decimal kawai - wannan shine LOG10. Wannan tsari yana saita tushe zuwa 10. Bayan zaɓar aikin LOG10, mai amfani zai buƙaci shigar da lambar kawai daga inda za a ƙididdige logarithm, kuma za a saita tushe ta atomatik zuwa 10. Shigar da dabara yayi kama da haka: =shiga10 (lamba).

Yadda ake amfani da aikin logarithmic a cikin Excel

Ba tare da la'akari da nau'in software da aka sanya akan kwamfutar ba, lissafin logarithms ya kasu zuwa matakai da yawa:

• Kaddamar da Excel kuma ƙirƙirar ƙaramin tebur mai shafi biyu.
• Rubuta kowane lambobi bakwai a shafi na farko. An zaɓi lambar su bisa ga shawarar mai amfani. Shafi na biyu zai nuna ƙimar logarithms na ƙimar lambobi.

• Danna LMB akan lamba a shafi na farko don zaɓar ta.
• Nemo gunkin aikin lissafi a gefen hagu na mashayin dabara kuma danna kan shi. Wannan aikin yana nufin "Saka Aiki".

• Bayan yin magudin da ya gabata, za a nuna taga "Saka aikin". Anan kana buƙatar faɗaɗa ginshiƙin “Kategory” ta danna kibiya a dama, zaɓi zaɓin “Math” daga lissafin kuma danna “Ok”.
• A cikin jerin ma'aikatan da ke buɗewa, danna kan layin "LOG", sannan danna "Ok" don tabbatar da aikin. Menu saitin tsarin logarithmic yakamata a nuna yanzu.

• Ƙayyade bayanai don lissafin. A cikin filin "Lambar", kuna buƙatar rubuta ƙimar lambobi daga abin da za a lissafta logarithm ta danna kan tantanin halitta mai dacewa a cikin teburin da aka ƙirƙira, kuma a cikin layin "Base", a cikin wannan yanayin, kuna buƙatar shigar da lambar. lamba 3.

• Danna "Enter" ko "Ok" a kasan taga kuma duba sakamakon. Idan an yi ayyukan daidai, to, sakamakon ƙididdige logarithm za a nuna shi a cikin tantanin halitta da aka zaɓa a baya na tebur. Idan ka danna wannan lambar, to, tsarin lissafi zai bayyana a cikin layin da ke sama.

• Yi wannan aiki tare da sauran lambobi a cikin tebur don lissafin logarithm.

Ƙarin Bayani! A cikin Excel, ba lallai ba ne a yi lissafin logarithm na kowane lamba da hannu. Don sauƙaƙe ƙididdiga da adana lokaci, kuna buƙatar matsar da alamar linzamin kwamfuta akan giciye a cikin ƙananan kusurwar dama na tantanin halitta tare da ƙididdige ƙimar, riƙe LMB kuma ja dabarar zuwa ragowar layin tebur don cika su a ciki. ta atomatik. Bugu da ƙari, za a rubuta tsarin da ake so don kowane lamba.

Amfani da bayanin LOG10 a cikin Excel

Dangane da misalin da aka tattauna a sama, zaku iya nazarin aikin LOG10. Don sauƙaƙe aikin, bari mu bar tebur tare da lambobi iri ɗaya, bayan share logarithms da aka lissafta a baya a shafi na biyu. Ana iya siffanta ka'idar aiki na ma'aikacin LOG10 kamar haka:

• Zaɓi tantanin halitta na farko a cikin shafi na biyu na tebur kuma danna maɓallin "Saka aikin" a gefen hagu na layin don shigar da dabaru.
• Dangane da tsarin da aka tattauna a sama, nuna nau'in "Mathematics", zaɓi aikin "LOG10" sannan danna "Shigar" ko danna "Ok" a ƙasan taga "Saka aikin".
• A cikin menu na "Ayyukan Aiki" wanda ke buɗewa, kuna buƙatar shigar da ƙimar lambobi kawai, gwargwadon abin da za a yi logarithm. A cikin wannan filin, dole ne ka saka magana zuwa tantanin halitta mai lamba a cikin tebur na tushe.

• Danna "Ok" ko "Enter" kuma duba sakamakon. A cikin shafi na biyu, ya kamata a ƙididdige logarithm na ƙayyadadden ƙimar ƙima.
• Hakazalika, shimfiɗa ƙimar ƙididdiga zuwa ragowar layuka a cikin tebur.

Muhimmin! Lokacin kafa logarithms a cikin Excel, a cikin filin "Lambar", zaku iya rubuta lambobin da ake so da hannu daga tebur.

Madadin Hanyar don Lissafin Logarithms a cikin Excel

Microsoft Office Excel yana da hanya mafi sauƙi don lissafin logarithms na wasu lambobi. Yana taimakawa wajen adana lokacin da ake buƙata don yin aikin lissafi. An raba wannan hanyar lissafin zuwa matakai masu zuwa:

• A cikin tantanin halitta kyauta na shirin, rubuta lambar 100. Kuna iya ƙayyade kowane darajar, ba kome ba.
• Zaɓi wani tantanin halitta kyauta tare da siginan linzamin kwamfuta.
• Matsa zuwa mashaya dabara a saman babban menu na shirin.
• Rubuta dabarar "=shiga(lamba; [bas])"kuma danna "Enter". A cikin wannan misali, bayan buɗe maƙallan, zaɓi tare da linzamin kwamfuta tantanin halitta da aka rubuta lamba 100, sa'an nan kuma sanya semicolon da nuna tushe, misali 10. Bayan haka, rufe sashin kuma danna "Enter" don kammala. dabara. Za a ƙididdige ƙimar ta atomatik.

Kula! Ana yin lissafin logarithms mai sauri ta hanyar amfani da mai aiki na LOG10.

Kammalawa

Don haka, a cikin Excel, ana ƙididdige algorithms ta amfani da ayyukan "LOG" da "LOG10" a cikin mafi ƙarancin lokaci mai yiwuwa. An kwatanta hanyoyin lissafin dalla-dalla a sama, ta yadda kowane mai amfani zai iya zaɓar zaɓi mafi dacewa da kansa.