Zolakwika za Common Excel formula ndi momwe mungakonzere

Pali zolakwika ziwiri zosiyana zomwe mungawone mu Excel. Tawonani zina mwazofala komanso momwe mungakonzere.

1. # Mtengo : Yesani kuchotsa mipata mu fomula kapena data mu cell sheet, ndikuwona mawuwo kuti apeze zilembo zapadera. Muyeneranso kuyesa kugwiritsa ntchito mapulogalamu m'malo mogwiritsa ntchito.
2. Dzina#:  Gwiritsani ntchito chogwirira ntchito kuti mupewe zolakwika za galamala. Sankhani cell yomwe ili ndi fomula, ndi tabu fomula , Dinani pa  lowetsani ntchito .
3. #####: Dinani kawiri mutu womwe uli pamwamba pa selo kapena mbali ya gawolo kuti muuwonjezere kuti ugwirizane ndi deta.
4. #NUM:  Onani manambala ndi mitundu ya data kuti mukonze izi. Vutoli limachitika mukalowetsa nambala yokhala ndi mtundu wa data wosachirikizidwa kapena mtundu wa manambala mugawo lotsutsana la fomula.

Monga munthu yemwe amagwira ntchito mubizinesi yaying'ono kapena kwina kulikonse, mukugwira ntchito pa Excel spreadsheet, mutha kukumana ndi cholakwika nthawi zina. Izi zitha kukhala pazifukwa zosiyanasiyana, kaya ndi zolakwika mu data yanu, kapena cholakwika munjira yanu. Pali zolakwika zingapo zoyimira izi, ndipo mu kalozera waposachedwa wa Microsoft 365, tifotokoza momwe mungakonzere.

Momwe mungapewere zolakwika

Tisanalowe mu zolakwika za formula, tiwona momwe tingapewere kwathunthu. Ma formula aziyamba ndi chikwangwani chofanana, ndipo onetsetsani kuti mwachulukitsa "*" m'malo mwa "x". Kuphatikiza apo, yang'anani momwe mumagwiritsira ntchito mabatani muzolemba zanu. Pomaliza, onetsetsani kuti mukugwiritsa ntchito mawu ogwidwa kuzungulira mawuwo m'mawu anu. Ndi malangizo ofunikira awa, simungakumane ndi zomwe tikambirana. Koma, ngati mudakalipo, tili ndi nsana wanu.

Cholakwika (#mtengo!)

Cholakwika chodziwika bwino ichi mu Excel chimachitika ngati pali cholakwika ndi momwe mumalembera fomula yanu. Itha kuwonetsanso mkhalidwe womwe china chake chalakwika ndi ma cell omwe mukulozera. Microsoft imanena kuti izi ndi zolakwika mu Excel, kotero ndizovuta kupeza chifukwa choyenera cha izi. Nthawi zambiri, ndi vuto lochotsa kapena malo ndi zolemba.

Monga kukonza, muyenera kuyesa kuchotsa mipata mu fomula kapena deta mu cell sheet, ndikuyang'ana zolemba za zilembo zapadera. Muyenera kuyesanso kugwiritsa ntchito magwiridwe antchito m'malo mogwiritsa ntchito, kapena kuyesa kuwunika komwe kwachokera zolakwika zanu podina njira Ndiye Kuwunika kwa formula Ndiye Kuwunika. Ngati zonse zitakanika, tikupemphani kuti muwone tsamba lothandizira la Microsoft, Pano Kuti mudziwe zambiri.

Cholakwika (#Name)

Cholakwika china chodziwika ndi #Name . Izi zimachitika mukayika dzina lolakwika munjira kapena fomula. Izi zikutanthauza kuti chinachake chiyenera kukonzedwa mu syntax. Kuti mupewe cholakwika ichi, tikulimbikitsidwa kugwiritsa ntchito fomula wizard mu Excel. Mukayamba kulemba dzina la fomula mu selo kapena mu kapamwamba ka fomula, mndandanda wa mafomu ofananira ndi mawu omwe mwalembawo umawonekera pamndandanda wotsikira pansi. Sankhani mawonekedwe apa kuti mupewe zovuta.

M'malo mwake, Microsoft ikuwonetsa kugwiritsa ntchito Function Wizard kuti mupewe zolakwika za galamala. Sankhani cell yomwe ili ndi fomula, ndi tabu fomula , Dinani pa lowetsani ntchito . Pambuyo pake Excel idzakutsegulirani wizard yanu.

Cholakwika #####

Chachitatu pamndandanda wathu ndi chimodzi chomwe mwachiwonapo kwambiri. Ndi cholakwika #####, zinthu zitha kukonzedwa mosavuta. Izi zimachitika pamene chinachake chalakwika ndi mawonekedwe a spreadsheet, ndipo Excel sangathe kusonyeza deta kapena zilembo muzanja kapena mizere monga momwe muliri. Kuti mukonze vutoli, ingodinani kawiri mutu womwe uli pamwamba pa selo kapena mbali ya gawolo kuti muuwonjezere kuti ugwirizane ndi deta yokha. Kapena kokerani mipiringidzo ya ndimeyo kapena mzerewo kupita kunja mpaka muwone deta ikuwonekera mkati.

Cholakwika #NUM

Chotsatira ndi #NUM. Pankhaniyi, Excel idzawonetsa cholakwika ichi ngati fomula kapena ntchitoyo ili ndi manambala olakwika. Izi zimachitika mukayika nambala pogwiritsa ntchito mtundu wa data kapena mtundu wa nambala womwe sunagwiritsidwe ntchito pagawo lotsutsa lachilinganizo.
Mwachitsanzo, $1000 singagwiritsidwe ntchito ngati mtengo wandalama.
Izi zili choncho chifukwa, mu ndondomekoyi, zizindikiro za dola zimagwiritsidwa ntchito ngati zolozera zenizeni ndi commas monga olekanitsa apakatikati mumapangidwe.
Onani manambala ndi mitundu ya data kuti mukonze izi.

Zolakwa zina

Tangokhudza zolakwika zofala, koma pali ena ochepa omwe tikufuna kuwatchula mwachangu. Chimodzi mwa izi ndi #DIV/0 . Izi zimachitika ngati nambala yomwe ili m'seloyo yagawidwa ndi ziro kapena ngati mu cell mulibe phindu lililonse.
Palinso, naponso #N / A , zomwe zikutanthauza kuti fomula silingapeze zomwe idafunsidwa kuti lifufuze.
wina ndi #Nkhani. Izi zimawoneka ngati wogwiritsa ntchito molakwika agwiritsidwa ntchito mu fomula.
Pomaliza, pali #REF. Izi zimachitika nthawi zambiri mukachotsa kapena kumata ma cell omwe akufotokozedwa ndi ma formula.

Maupangiri 5 apamwamba a Microsoft Excel mu Office 365