Momwe mungachulukitsire bwino

Wopambana pulogalamu ya pulogalamu ya pulosesa ya Microsoft Excel angathe kuchulukitsa mosavuta nambala yanu iliyonse ndi mndandanda. Kodi zingakhale zothandiza liti pankhaniyi? Pali zambiri zomwe mungachite:

• Pafupi palibe cholembera.
• Manambala ambiri amachulukitsidwa, ndipo m'pofunika kuwona chiwerengero chomwe chikuphatikizidwa, ndipo mwinamwake kuti muwabwezeretse ena (mu chiwerengero chodziwika popanda ntchito yopulumutsa mzere, muyenera kuyamba kuwerenganso).
• Kuwonjezeka ndi gawo limodzi la njira yowonjezera.

Monga mukuonera, kuchulukitsa mu Excel si chinthu chopanda pake. Popanda ntchito yowonjezera, palibe njira imodzi yomwe ingaperekedwe ndi.

Zowonjezera zosankhidwa mu Excel

"Excel" imakupatsani inu kuchulukitsa limodzi ndi limodzi:

• Nambala yapadera (zabwino, zoipa, integer, fractional).
• Nambala kuchokera ku maselo omwe amasonyeza.
• Mitundu ya manambala.
• Zofunika za Boolean

Kodi kuchulukitsa kumachitika motani? Njira yowonjezera mu Excel imayamba ndi chizindikiro chofanana (=). Monga mwa njira iliyonse, chiwerengero chimodzi kapena zingapo (kapena zogwirizana ndi maselo omwe ali nazo) zimasonyezedwa, zotsatiridwa ndi asterisk (*). Njira imeneyi idzawoneka ngati izi: "= 0.22 * -5 * 16" (pamene nambala yowonjezera yawonjezeka), kapena "= G4 * I5" (pamene mafotokozedwe a selo akufotokozedwa ngati zifukwa). Ichi ndi choyamba chochulukitsa.

Njira yowonjezera mu Excel ingalembedwe pogwiritsira ntchito ntchito "YOPHUNZITSIDWA" yowonjezera:

Ubwino wogwiritsira ntchito ntchitoyi kuwonjezerapo mu Excel ndi mwayi wochulukitsa wina osati machaputala komanso mndandanda.

Tiyeni titembenuzire ku zitsanzo za konkire.

Kuwonjezeka ndi asterisk

Yesani zitsanzo zotsatirazi pa tsamba la Excel:

Pakati pawo mudzawona kuti ndi zophweka kwambiri kubweretsa ku Excel. Onani kuti zotsatira zowonjezera mfundo zoyenera ndi 0 (FALSE) kapena 1 (TRUE).

Chokhacho chokha cha njira yowonjezera ndi chakuti sungakhoze kulandira manambala angapo monga kutsutsana. Zoonadi, chiwerengero chimene munthu aliyense wogwiritsa ntchito angakwanitse chidzatsimikiziridwa penapake kumapeto kwa chiwerengero cha chiwerengero cha ma number kapena maselo omwe amatsatiridwa ndikusintha ndi zizindikiro za asterisk.

Njira yokhayo yoyendera kuzungulira izi ndi kugwiritsa ntchito ntchito "NTCHITO".

Kuwonjezeka ndi ntchito "NTCHITO"

Lingalirani momwe mungapangire kuchulukitsa mu Excel pogwiritsa ntchito ntchito yomangidwa.

Mu bukhu la ntchito ya Excel, pangani piritsi yofanana ndikuyang'ana zitsanzo pa izo. Mu khola limodzi, onjezerani malingaliro angapo, mu gawo lina, komanso lowetsani miyezo yambiri. Yesetsani kugwiritsa ntchito "NTCHITO" ntchito kumagulu anu, komanso muzichulukitsa mwa kugwiritsa ntchito asterisk.

Mu gawo la "Formule" la tebulo ili likuwonetsedwanso bwino kuti ngati miyezo ya makhalidwe imayimilira, ndiye ikhonza kugwiritsidwa ntchito ngati umodzi. Ndiponso malinga ndi gome, mukhoza kuona kuti ntchito "NTCHITO" inachulukitsa chiwerengero chonse cha mndandanda womwewo, ndipo zotsatira zake zimakhala zofanana ndi ngati ife timachulukitsa maulendo kuchokera ku maselo opatsidwawo panthawi imodzi. Monga mukuonera, kuchulukitsa mu Excel sikovuta.

Chochititsa chidwi! Yesani tsopano kuchotsa mtengo umodzi kuchoka pa selo iliyonse, mulole selo likhale lopanda kanthu. Mudzawona kuti pakuchita chomwecho, ntchito ya MESSAGE inachititsa chiwerengerochi mwa kumasula selo yopanda kanthu. Koma zotsatira za kuchulukitsa "manual" zinasanduka zero. Uku ndi kupindula kwina kodziwika kwa ntchito yomangidwira isanafike kuchulukitsidwa ndi asterisk - sizitenga maselo opanda kanthu monga zero, zimangowatulutsa kuwerengera.

Pali zochitika pamene mawerengedwe amapangidwa pa masamba angapo a bukhuli, ndipo pepala lomaliza limaphatikizapo ndondomeko yomwe imaphatikizapo chigamulo cha machitidwe kuchokera kumapiritsi ena. Ngati chimodzi mwa izo sichidzadziwika, kuchulukitsa kophweka ndi asterisk kudzasintha zotsatira zanu zonse.

Kuchokera pa izi zingatheke kuti pochita zovuta zowerengera pamapepala angapo, ndi bwino kugwiritsa ntchito ntchito "NTCHITO" monga chofunika.

Gulu lowonjezera

Tiyeni tiwone pamapeto momwe tingapangire tebulo lokwanira mu Excel. Ndi zophweka.

Mu miyambo ya matebulo ophatikizira, tidzasintha manambala amodzi ku chigawo, ndi mzere umodzi kupita ku wina. Kuti mukhoze kufotokoza ma fomu, muyenera kugwiritsa ntchito maulumikilo osakanikirana - kukonza ndi chizindikiro cha dola ($) nambala yachonde ndi deta yokonzedweratu deta ndi mizere yokhala ndi deta yosakanikirana: "= $ A2 * B $ 1".