Kuthiwani-uma ukuhlaziywa ku-Excel

I-Excel iqukethe amathuluzi amaningi anamandla okwenza izibalo eziyinkimbinkimbi zezibalo, njenge Kuthiwani uma ukuhlaziywa. Leli thuluzi liyakwazi ukuthola isisombululo kudatha yakho yangempela, noma ngabe idatha ingaphelele. Kulesi sifundo uzofunda ukuthi ungasebenzisa kanjani elinye lamathuluzi “kuthiwani uma” ukuhlaziya esibizwa Ukukhetha ipharamitha.

Ukukhetha ipharamitha

Ngaso sonke isikhathi uma usebenzisa ifomula noma umsebenzi ku-Excel, uqoqa amanani angempela ndawonye ukuze uthole umphumela. Ukukhetha ipharamitha isebenza ngenye indlela. Ivumela, ngokusekelwe kumphumela wokugcina, ukubala inani lokuqala elizonikeza umphumela onjalo. Ngezansi sinikeza izibonelo ezithile ukukhombisa ukuthi isebenza kanjani. Ukukhetha ipharamitha.

Indlela yokusebenzisa Ukukhetha Ipharamitha (isibonelo 1):

Ake sithi uya esikhungweni semfundo esithile. Okwamanje, usuzuze amaphuzu angama-65, futhi udinga okungenani amaphuzu angama-70 ukuze uphumelele ukukhetha. Ngenhlanhla, kunomsebenzi wokugcina ongakhuphula amaphuzu akho. Kulesi simo, ungasebenzisa Ukukhetha ipharamithaukuthola ukuthi yimaphi amaphuzu owadingayo ukuze uthole umsebenzi wokugcina ukuze ungene esikhungweni semfundo.

Esithombeni esingezansi, ungabona ukuthi amaphuzu akho emisebenzi emibili yokuqala (ukuhlola nokubhala) angama-58, 70, 72, kanye nama-60. Nakuba singazi ukuthi isikolo sakho somsebenzi wokugcina (ukuhlola 3) sizoba yini. , singabhala ifomula ebala isilinganiso samaphuzu ayo yonke imisebenzi ngesikhathi esisodwa. Esikudingayo nje ukubala incazelo ye-arithmetic yazo zonke izilinganiso ezinhlanu. Ukuze wenze lokhu, faka isisho =INKOSI(B2:B6) kuseli B7. Ngemva kokufaka isicelo Ukukhetha ipharamitha Ukuze uxazulule le nkinga, iseli B6 izobonisa amaphuzu amancane okudingeka uwathole ukuze ungene esikhungweni semfundo.

1. Khetha iseli ofuna ukulithola inani lalo. Ngaso sonke isikhathi uma usebenzisa ithuluzi Ukukhetha ipharamitha, Udinga ukukhetha iseli eseliqukethe ifomula noma umsebenzi. Esimweni sethu, sizokhetha iseli B7 ngoba iqukethe ifomula =INKOSI(B2:B6).
2. Kuthebhu ethuthukisiwe Idatha khetha iqembu Kuthiwani uma ukuhlaziywa, bese uchofoza kumenyu yokudonsela phansi Ukukhetha ipharamitha.
3. Ibhokisi lengxoxo lizovela elinezinkambu ezintathu:
   • Mouthbuyekeza kuseli iyiseli eliqukethe umphumela oyifunayo. Esimweni sethu, lena iseli B7 futhi sesivele siyikhethile.
   • Value umphumela oyifunayo, okungukuthi umphumela okufanele ube kuseli B7. Esibonelweni sethu, sizofaka u-70 ngoba udinga ukuthola okungenani u-70 ukuze ungene.
   • Ukushintsha inani leseli – iseli lapho i-Excel izoveza khona umphumela. Esimweni sethu, sizokhetha iseli B6 ngoba sifuna ukwazi ibanga esifuna ukulithola emsebenzini wokugcina.
4. Ngemva kokuqeda zonke izinyathelo, chofoza OK.
5. I-Excel izobala umphumela nasebhokisini lengxoxo Umphumela wokukhetha ipharamitha hlinzeka ngesixazululo, uma sikhona. Chofoza OK.
6. Umphumela uzovela kuseli elishiwo. Esibonelweni sethu Ukukhetha ipharamitha setha ukuthi udinga ukuthola ubuncane bamaphuzu angama-90 ngomsebenzi wokugcina ukuze uqhubeke.

Indlela yokusebenzisa Ukukhetha Ipharamitha (isibonelo 2):

Ake sicabange ukuthi uhlela umcimbi futhi ufuna ukumema izivakashi eziningi ngangokunokwenzeka ukuze zihlale ngaphakathi kwesabelomali sika-$500. Ungasebenzisa Ukukhetha ipharamithaukubala inani lezimenywa ongazimema. Esibonelweni esilandelayo, iseli B4 liqukethe ifomula =B1+B2*B3, okuhlanganisa izindleko eziphelele zokuqasha igumbi kanye nezindleko zokusingatha zonke izihambeli (intengo yesivakashi esingu-1 iphindaphindwa ngenombolo yazo).

1. Khetha iseli ofuna ukushintsha inani lalo. Esimweni sethu, sizokhetha iseli B4.
2. Kuthebhu ethuthukisiwe Idatha khetha iqembu Kuthiwani uma ukuhlaziywa, bese uchofoza kumenyu yokudonsela phansi Ukukhetha ipharamitha.
3. Ibhokisi lengxoxo lizovela elinezinkambu ezintathu:
   • Уafakwe esitokisini iyiseli eliqukethe umphumela oyifunayo. Esibonelweni sethu, iseli B4 isivele ikhethiwe.
   • Value umphumela oyifunayo. Sizofaka angu-500 njengoba kwamukelekile ukusebenzisa u-$500.
   • Izinguqukoinani leseli – iseli lapho i-Excel izoveza khona umphumela. Sizogqamisa iseli B3 ngoba sidinga ukubala inani lezivakashi esingazimema ngaphandle kokweqa isabelomali sethu esingu-$500.
4. Ngemva kokuqeda zonke izinyathelo, chofoza OK.
5. Iwindi lengxoxo Umphumela wokukhetha ipharamitha izokwazisa uma isixazululo sesitholakele. Chofoza OK.
6. Umphumela uzovela kuseli elishiwo. Esimeni sethu Ukukhetha ipharamitha kubalwe umphumela 18,62. Njengoba sibala inani lezihambeli, impendulo yethu yokugcina kufanele ibe inombolo ephelele. Singakwazi ukusondeza umphumela phezulu noma phansi. Uma sihlanganisa inani lezivakashi, sizodlula isabelomali esinikeziwe, okusho ukuthi sizoma ezivakashini ezingu-18.

Njengoba ungabona esibonelweni sangaphambilini, kunezimo ezidinga inombolo ephelele njengomphumela. Uma a Ukukhetha ipharamitha ibuyisela inani ledesimali, ilizungezisa phezulu noma phansi ngendlela efanele.

Ezinye Izinhlobo Zokuhlaziya Okuthi-Uma

Ezinye izinhlobo zingasetshenziswa ukuxazulula izinkinga eziyinkimbinkimbi. “kuthiwani uma” ukuhlaziya - Izimo noma amathebula edatha. Ngokungafani Ukukhetha ipharamitha, eyakha phezu komphumela oyifunayo futhi isebenza emuva, lawa mathuluzi akuvumela ukuthi uhlaziye amanani amaningi futhi ubone ukuthi umphumela ushintsha kanjani.

• Дumphathi weskripthi ikuvumela ukuthi ushintshe amanani kumaseli amaningana ngesikhathi esisodwa (kufika ku-32). Ungakha imibhalo eminingi bese uyiqhathanisa ngaphandle kokushintsha amanani mathupha. Esibonelweni esilandelayo, sisebenzisa izimo ukuze siqhathanise izindawo ezimbalwa ezihlukene zomcimbi.
• Amathebula idatha ikuvumela ukuthi uthathe okuguquguqukayo okukodwa kokubili kufomula futhi ubeke esikhundleni sanoma iyiphi inombolo yamanani, futhi ufingqe imiphumela kuthebula. Leli thuluzi linamathuba abanzi kakhulu, njengoba libonisa imiphumela eminingi ngesikhathi esisodwa, ngokungafani Isiphathi Seskripthi or Ukukhetha ipharamitha. Isibonelo esilandelayo sibonisa imiphumela engama-24 engaba khona yezinkokhelo zenyanga zonke zemalimboleko: