Maitiro ekuverenga logarithm muExcel. LOG basa rekuverenga iyo logarithm muExcel

Microsoft Excel ine nhamba huru yemabasa ayo anokubvumira kukurumidza kuita masvomhu kuverenga. Imwe yeanonyanya kuzivikanwa uye akakurumbira mabasa ndeye LOG, iyo inogona kushandiswa kuverenga logarithms. Ichi chinyorwa chichakurukura nheyo yekushanda kwayo uye maitiro ehutano.

Maitiro ekuverenga logarithm muExcel

LOG inobvumidza iwe kuti uverenge logarithm yenhamba kune yakatsanangurwa base. Kazhinji, fomula yelogarithm muExcel, zvisinei neshanduro yechirongwa, yakanyorwa seizvi: =log(nhamba;[base]). Pane zvirevo zviviri mufomula yakapihwa:

• Number. Uhwu ndihwo kukosha kwenhamba yakapinda nemushandisi panozoverengerwa logarithm. Nhamba yacho inogona kuiswa nemaoko mundima yekuisa fomula, kana iwe unogona kunongedza mbeva cursor kune yaunoda sero ine kukosha kwakanyorwa.
• Base. Ichi ndicho chimwe chezvikamu zvelogarithm iyo inoverengwa nayo. Hwaro hunogonawo kunyorwa senhamba.

Teerera! Kana hwaro hwelogarithm husina kuzadzwa muExcel, chirongwa chinozongoisa kukosha kune zero.

Maitiro ekuverenga decimal logarithm muMicrosoft Excel

Kuti zvive nyore kuverenga, Excel ine basa rakasiyana rinoverenga chete decimal logarithms - iyi iLOG10. Iyi fomula inoisa hwaro ku10. Mushure mekusarudza iyo LOG10 basa, mushandisi anongoda kuisa nhamba kubva iyo iyo logarithm ichaverengerwa, uye hwaro hunoiswa otomatiki ku10. Iyo formula yekupinda inoita seizvi: =log10(nhamba).

Maitiro ekushandisa logarithmic basa muExcel

Pasinei neshanduro yesoftware yakaiswa pakombuta, kuverenga kwelogarithms kwakakamurwa kuita matanho akati wandei:

• Tangisa Excel uye gadzira diki-makoramu tafura.
• Nyora chero nhamba nomwe muchikamu chekutanga. Nhamba yavo inosarudzwa pakufunga kwemushandisi. Chikamu chechipiri chicharatidza kukosha kwelogarithms yehuwandu hwehuwandu.

• Dzvanya LMB panhamba iri mukoramu yekutanga kuti uisarudzire.
• Tsvaga iyo math function icon kuruboshwe rweformula bar uye tinya pairi. Ichi chiito chinoreva "Isa Basa".

• Mushure mekuita kunyengedza kwekare, hwindo re "Insert function" richaratidzwa. Pano iwe unofanirwa kuwedzera iyo "Category" column nekudzvanya pane museve uri kurudyi, sarudza iyo "Math" sarudzo kubva pane iyo rondedzero uye tinya pakanzi "OK".
• Mune rondedzero yevashandisi inovhura, tinya pakanzi "LOG", wobva wadzvanya pakanzi "OK" kusimbisa chiitiko. Iyo logarithmic formula yekuseta menyu inofanirwa kuratidzwa ikozvino.

• Tsanangura iyo data yekuverenga. Mundima ye "Nhamba", iwe unofanirwa kunyora kukosha kwenhamba kubva iyo logarithm ichaverengerwa nekudzvanya pane inoenderana sero mutafura yakagadzirwa, uye mumutsara we "Base", mune iyi kesi, iwe uchafanirwa kupinda nhamba 3.

• Dzvanya "Enter" kana "OK" pazasi pehwindo uye tarisa mhedzisiro. Kana zviito zvikaitwa nemazvo, ipapo mhedzisiro yekuverenga logarithm icharatidzwa mune yakambosarudzwa sero yetafura. Kana ukadzvanya panhamba iyi, ipapo fomula yekuverenga ichaonekwa mumutsetse uri pamusoro.

• Ita basa rimwe chete nenhamba dzasara mutafura kuti uverenge logarithm yavo.

Mamwe Mashoko! MuExcel, hazvidi kuti uverenge nemaoko logarithm yenhamba yega yega. Kurerutsa kuverenga uye kuchengetedza nguva, unofanirwa kufambisa chinongedzo chembeva pamusoro pemuchinjikwa mukona yekurudyi yesero ine kukosha kwakaverengerwa, bata pasi LMB uye dhonza formula kune yasara mitsetse yetafura kuti izadzwe mukati. automatic. Uyezve, fomula inodiwa ichanyorwa kune imwe neimwe nhamba.

Uchishandisa chirevo cheLOG10 muExcel

Kubva pamuenzaniso wakurukurwa pamusoro, unogona kudzidza kushanda kweLOG10 basa. Kuti basa rive nyore, ngatisiyei tafura nenhamba dzakafanana, mushure mekudzima iyo yakamboverengerwa logarithms mumutsara wechipiri. Nheyo yekushanda kweLOG10 mushandisi inogona kutsanangurwa seizvi:

• Sarudza sero rekutanga muchikamu chechipiri chetafura uye tinya bhatani re "Insert function" kuruboshwe rwemutsara kuti uise mafomula.
• Zvinoenderana nechirongwa chakurukurwa pamusoro, ratidza chikamu che "Mathematics", sarudza basa "LOG10" uye tinya "Pinda" kana tinya pakanzi "OK" pazasi pe "Insert function" hwindo.
• Mu "Function Arguments" menyu inovhura, iwe unofanirwa kuisa chete nhamba yenhamba, zvichienderana neiyo iyo logarithm ichaitwa. Mundima iyi, iwe unofanirwa kutsanangura chirevo chesero ine nhamba iri mudura retafura.

• Dzvanya "OK" kana "Enter" uye tarisa mhedzisiro. Muchikamu chechipiri, logarithm yenhamba yakatsanangurwa inokosha inofanira kuverengwa.
• Saizvozvowo, tambanudza kukosha kwakaverengwa kune mitsara yakasara mutafura.

Zvinokosha! Pakumisa logarithms muExcel, mundima ye "Nhamba", iwe unogona kunyora nemaoko nhamba dzinodiwa kubva patafura.

Imwe nzira yekuverenga Logarithms muExcel

Microsoft Office Excel ine nzira iri nyore yekuverenga logarithms yedzimwe nhamba. Inobatsira kuchengetedza nguva inodiwa kuita basa remasvomhu. Iyi nzira yekuverenga yakakamurwa kuita zvinotevera:

• Muchisero chemahara chepurogiramu, nyora nhamba 100. Unogona kutsanangura chero humwe hunokosha, hazvina basa.
• Sarudza imwe sero yemahara ine mouse cursor.
• Enda kune formula bar kumusoro kweiyo huru chirongwa menyu.
• Nyora fomu =log(nhamba;[base])” uye tinya “Enter”. Mumuenzaniso uyu, mushure mekuvhura bhuraketi, sarudza nembeva sero iyo yakanyorwa nhamba 100, woisa semicolon uye ratidza hwaro, semuenzaniso 10. Zvadaro, vhara bhaketi uye tinya "Pinda" kuti upedze formula. Kukosha kuchaverengerwa otomatiki.

Teerera! Kuverengera nekukurumidza kwedesimali logarithms kunoitwa zvakafanana uchishandisa LOG10 opareta.

mhedziso

Saka, muExcel, maalgorithms anoverengerwa uchishandisa "LOG" uye "LOG10" mabasa munguva pfupi pfupi inobvira. Nzira dzekuverenga dzakatsanangurwa zvakadzama pamusoro apa, kuitira kuti mushandisi wega wega akwanise kuzvisarudzira sarudzo yakasarudzika.