Barka da rana
Na dauki lokaci mai tsawo ban rubuta wani rubutu akan Magana da Excel a shafukan yanar gizo ba. Kuma yanzu, in mun gwada da kwanan nan, na sami wata tambaya mai ban sha'awa daga ɗayan masu karatu: "yadda za a cire tushen digirin nth daga lamba a cikin Excel." Tabbas, kamar yadda na iya tunawa, Excel yana da aikin "Tushen", amma kawai yana fitar da tushen murabba'i, idan kuna buƙatar tushen wani matakin?
Sabili da haka ...
Af, misalai da ke ƙasa za su yi aiki a cikin Excel 2010-2013 (ban bincika aikinsu a cikin sauran sigogin ba, kuma ba zan iya faɗi ba idan zai yi aiki).
Kamar yadda aka sani daga lissafi, tushen kowane digiri n lambar yana daidai yake da haɓakawa zuwa ƙarfin lamba ɗaya ta 1 / n. Don yin wannan doka ta zama mai haske, zan ba da hoto kaɗan (duba ƙasa).
Tushen ukun 27 shine 3 (3 * 3 * 3 = 27).
A cikin Excel, haɓakawa zuwa iko yana da sauƙin sauƙi, don wannan ana amfani da alama ta musamman ^ (“Murfi”, galibi irin wannan alamar ana samunsa akan maɓallin “6”).
I.e. don cire tushen digirin nth daga kowane lamba (alal misali, daga 27), yakamata a rubuta dabara kamar haka:
=27^(1/3)
inda 27 shine lambar daga inda muke cire tushen;
3 - digiri.
Misalin aikin da ke ƙasa a cikin allo.
Tushen digiri na 4 daga 16 shine 2 (2 * 2 * 2 * 2 = 16).
Af, za a iya rubuta digiri nan da nan a cikin hanyar adadi na lamba. Misali, maimakon 1/4, zaku iya rubuta 0.25, sakamakon zai zama iri ɗaya, amma iyawar gani ta fi girma (dacewa da tsari mai tsayi da ƙididdigar manya).
Shi ke nan, kyakkyawan aiki a cikin Excel ...
