Ngati mwakhala mukugwira ntchito ku Excel kwa nthawi yopitilira tsiku lachiwiri, ndiye kuti mwakumana kale kapena mwagwiritsa ntchito zikwangwani za dollar muzolemba za Excel ndi ntchito, mwachitsanzo. $D $2 or F$3 etc. Tiyeni potsiriza kulingalira chimene kwenikweni iwo akutanthauza, momwe iwo ntchito ndi kumene angakhale zothandiza wanu owona.
Maulalo achibale
Awa ndi maumboni okhazikika ngati nambala ya mzere wa zilembo ( A1, C5, mwachitsanzo, "nkhondo yankhondo") yomwe imapezeka m'mafayilo ambiri a Excel. Chodabwitsa chawo ndikuti amasinthidwa akamakopera mafomu. Iwo. C5, mwachitsanzo, amasanduka C6, C7 etc. pokopera pansi kapena ku D5, E5 etc. pokopera kumanja, ndi zina zotero. Nthawi zambiri, izi ndi zachilendo ndipo sizimayambitsa mavuto:
Maulalo osakanikirana
Nthawi zina mfundo yoti ulalo womwe uli mu fomula, ukakopera, "slide" wokhudzana ndi selo loyambirira ndi wosafunika. Kenako, kukonza ulalo, chizindikiro cha dola ($) chimagwiritsidwa ntchito, chomwe chimakulolani kukonza zomwe zikubwera kale. Choncho, mwachitsanzo, kugwirizana $C5 sichidzasintha m'mipingo (ie С sichidzasanduka D, E or F), koma akhoza kusuntha kudutsa mizere (ie akhoza kusuntha $C6, $C7 etc.). Momwemonso, C$5 - sichidzasuntha m'mizere, koma ikhoza "kuyenda" pamizere. Maulalo oterowo amatchedwa zosakaniza:
Mtheradi maulalo
Chabwino, ngati muwonjeza ndalama zonse ziwiri ku ulalo nthawi imodzi ($ 5 $) - zidzasanduka Mtheradi ndipo sizisintha mwanjira iliyonse pakukopera kulikonse, mwachitsanzo, madola amakhazikika mwamphamvu ndi mzere ndi mzere:
Njira yosavuta komanso yachangu kwambiri yosinthira mawu achibale kuti akhale mtheradi kapena osakanikirana ndikusankha mu fomula ndikusindikiza batani la F4 kangapo. Chinsinsichi chimazungulira zonse zinayi zomwe zingatheke pokonza ulalo wa cell: C5 → $ 5 $ → $C5 → C$5 ndi mobwerezabwereza.
Chilichonse ndi chosavuta komanso chomveka. Koma pali mmodzi "koma".
Tiyerekeze kuti tikufuna kupanga tsatanetsatane wa cell C5. Zoti nthawi zonse ankazitchula C5 mosasamala kanthu kena kalikonse kogwiritsa ntchito. Zimakhala zoseketsa - ngakhale mutapanga ulalo kukhala wokwanira (ie $ 5 $), zimasinthabe nthawi zina. Mwachitsanzo: Mukachotsa mzere wachitatu ndi wachinayi, usintha kukhala $ 3 $. Ngati mulowetsa mzati kumanzere С, ndiye idzasintha kukhala D. Ngati mudula selo C5 ndi kumata mu F7, ndiye idzasintha kukhala F7 ndi zina zotero. Bwanji ngati ndikufuna ulalo wovuta kwambiri womwe ungatchulepo nthawi zonse C5 ndipo palibe china chilichonse muzochitika zilizonse kapena zochita za ogwiritsa ntchito?
Mtheradi maulalo
Chotsatira ndicho kugwiritsa ntchito KUMALO (KODI), yomwe imapanga zolembera za selo kuchokera ku chingwe cha malemba.
Mukayika fomula mu cell:
= INDIRECT(“C5”)
= INDIRECT(«C5»)
ndiye nthawi zonse imaloza ku cell yokhala ndi adilesi C5 mosasamala kanthu za zochita zina za wogwiritsa ntchito, kuyika kapena kufufuta mizere, ndi zina zotero. Vuto lokhalo laling'ono ndiloti ngati selo yomwe mukufunayo ilibe, ndiye KUMALO zotuluka 0, zomwe sizothandiza nthawi zonse. Komabe, izi zitha kuzunguliridwa mosavuta pogwiritsa ntchito zomangamanga zovuta kwambiri ndi cheke kudzera mu ntchitoyi ISBLANK:
=IF(ISNULL(INDIRECT(“C5″))),””, INDIRECT(“C5”))
=IF(ISBLANK(INDIRECT(«C5″));»»;INDIRECT(«C5»))
- Zofotokozera zamagulu a XNUMXD pakuphatikiza deta kuchokera pamagome angapo
- Chifukwa chiyani mukufunikira mawonekedwe a ulalo wa R1C1 ndi momwe mungaletsere
- Kukopera ndendende mafomu ndi macro ndi chowonjezera cha PLEX