Momwe mungapangire chizindikiro cha dollar mu njira yopambana

Njira 1: Kukhazikika kwa cell

Ngati pali ogwiritsa ntchito ambiri owonjezera $ ngati ndalama za ndalama, ndiye kuti ogwiritsa ntchito akudziwa amadziwika kuti ndi njirayi. Chizindikiro chowonedwa mu syntax cha pulogalamuyi chimakupatsani mwayi wokonza maselo aliwonse omwe akuphatikizidwa mu ntchito kuti ikatambasulidwa kapena kukopera, chipikacho sichisintha mu ntchitoyo. Tidzakambirana ntchito yokoperayo popanda kutchingira foni ndikuwona momwe zimakhudzira.

Pali ntchito yosavuta kwambiri yowonjezera magawo awiri kapena kupitilira apo mu maselo.

1. Dinani pa cell yomwe ili ndi batani la Formula Mbewu kuti muitane menyu ndikusankha njira ya "kope".



2. Kutsatira dinani ya LKM patchire yopanda kanthu, komwe timatchanso menyu yomweyo ndikupeza chinthucho "ikani maselo ojambulidwa".



3. Tikuwona kuti pulogalamuyi imangopereka njira ziwiri zokha zowonjezera, pomwe mitundu yonse idzasunthidwa kapena kumanja.



4. Pambuyo pa kuyikako, timayang'ana pa zomwe tidakumana nazo panali kusungunuka pansi, komwe kumakhudza maselo onse chifukwa sanakonzekere.

Tsopano lingalirani za ntchito yomweyi, koma inunso mudzakonza imodzi mwamakhalidwe pogwiritsa ntchito chikwangwani cha $ $, kenako onani momwe kukopera kudzachitika nthawi ino.

1. Kanikizani batani lakumanzere pa mzere ndi formula ndikupeza mtengo womwe mukufuna kuteteza.



2. Lowetsani chikwangwani cha chikwangwani cha chilembo cha mzere momwe zimasonyezeredwa mu chithunzi chotsatirachi. Mawuwa amatanthauza kuti khungu limakhazikika.



3. Kukulitsa kapena kukopera formula, kenako onani zomwe zasintha. Monga tikuwonera pazenera pansipa, mtengo wachiwiri wokha ndi wokhawo womwe udasunthidwa, ndipo okhazikika adatsalira pamalo omwewo.

Gwiritsani ntchito chidziwitsocho chomwe chapeza pazolinga zanu: Chotsani zovuta ndi njira zosinthira zofananira, kuwalitsa mosavuta ndikuwajambula.

Njira yachiwiri: Kuwonjezera $ ngati gawo la ndalama

Cholinga china ndikuwonjezera chikwangwani cha $ ndalama, chomwe ogwiritsa ntchito ena achulukitsa omwe akukumana nawo. Pachifukwa ichi, ndi zinthu zochepa chabe zosavuta zomwe zimasintha mtundu wa maselo.

1. Sonyezani mabatani onse omwe mukufuna kuwonjezera pa ndalama pazomwe mungachite.



2. Kenako dinani kumanja ndi mu mndandanda womwe umapezeka, pezani "mawonekedwe a foni".



3. Tabu yoyamba imatchedwa "nambala yakuti" pamndandanda wake "mitundu ya manambala" imawunikira chinthucho "ndalama".



4. Kukulitsa menyu yotsika ndi yodziwitsa.



5. Pezani malo a $ kumeneko, ndikutuluka mu ndalama zofunika.



6. Manambala olakwika, khazikitsani njira yoyeserera kapena siyani mtengo wokhazikika.



7. Mukatseka menyu, mutha kudziwa bwino zotsatira zake.



8. Ndi chilengedwe chowonjezera cha mafomu, sipayenera kukhala zovuta ndi kuwerengera, ndipo chikwangwani chimangowonjezera zotsatira mu cell.

Pali njira zowonjezera zomwe zimaloleza kusintha mtundu wa khungu, timangoganiza zodziwika kwambiri. Ngati mukufuna, dziwani za njira zina zomwe zikupezeka powerenga nkhaniyo pa ulalo womwe uli pansipa.

Werengani zambiri: Sinthani mawonekedwe a cell mu Excel