Good rana
Dogon lokaci ba a rubuta wani sakonni a kan Kalma da Excel akan shafukan yanar gizo ba. Kuma, ba kamar yadda ba a daɗe ba, na karbi wata tambaya mai ban sha'awa daga ɗayan masu karatu: "yadda za a cire tushen tushen n-daga cikin Excel." Lalle ne, har zuwa lokacin da na tuna, a cikin Excel akwai aikin "Tushen", amma yana cire kawai tushen tushen, idan kuna buƙatar tushen kowane digiri?
Sabili da haka ...
A hanyar, misalai da ke ƙasa za su yi aiki a Excel 2010-2013 (a wasu sassan ban duba aikin su ba, kuma ba zan iya cewa ko zai yi aiki ba).
Kamar yadda aka sani daga ilmin lissafi, tushen kowane digiri n na lamba zai kasance daidai da bayyanar wannan lamba ta 1 / n. Don yin wannan doka a bayyane, zan ba da wani ɗan hoto (duba ƙasa).
Tushen digiri na uku na 27 shine 3 (3 * 3 * 3 = 27).
A cikin Excel, ƙarfafa ikon yana da sauki, saboda wannan, ana amfani da alamar ta musamman. ^ ("rufe", yawanci wannan icon yana samuwa a kan "maɓallin" 6 "a kan keyboard).
Ee don cire tushen asalin kowane lamba (alal misali, daga 27), dole ne a rubuta takarda kamar:
=27^(1/3)
inda 27 shine lambar da muka cire tushen;
3 - digiri.
Misalin aikin da ke ƙasa a screenshot.
Tushen 4 na 16 shi ne 2 (2 * 2 * 2 * 2 = 16).
Ta hanyar, za a iya rubuta digiri a matsayinkaccen lambar adadi. Alal misali, a maimakon 1/4, zaku iya rubuta 0.25, sakamakon zai kasance iri ɗaya, kuma hangen nesa ya fi girma (mahimmanci don dogon lokaci da ƙididdiga masu yawa).
Wannan abu ne, aikin nasara a Excel ...
