Indlela yokuSebenzisa iMimiselo yokuFomathiza iMimiselo yeMigangatho yemihla kwi-Excel

Ukongeza ifomathi enemeko kwiselula kwi-Excel ikuvumela ukuba wenze izicelo ezahlukeneyo zokufomathiza, ezifana nombala, xa idatha kule seli ihlangabezana nezimo ozibekile.

Ukusebenzisa ukufomathiza okunemiqathango kulula, kukho izikhetho eziphambili ezikhoyo ezijongene neemeko eziqhelekileyo ezisetyenziswayo, njenge:

• Imihla
• Idatha yokuphinda
• Iimilinganiselo ezingentla okanye ngaphantsi kwexabiso eliqhelekileyo kwimiba yeeseli

Kwimeko yemihla, okukhethwa kwimiqathango equlunqwe kuqala kusenza kube lula ukujonga idatha yakho malunga neentsuku ezikufutshane nomhla wamanje, njengezolo, ngomso, ngeveki ephelileyo okanye ngenyanga ezayo.

Ukuba ufuna ukutshekisha iintsuku eziwela ngaphandle kweendlela ezikhethiweyo, kunjalo, unokwenza ifomathi engqinelanayo ngokwongezelela ifomu yakho usebenzisa enye okanye ngaphezulu kwemisebenzi yomhla ka-Excel.

01 ngo-06

Ukuhlolwa kweeDat 30, 60, kunye neentsuku ezingama-90 ezidlulileyo

Ukufomathiza ukufomatha komqathango usebenzisa iifomula kwenziwa ngokubeka umgaqo omtsha olandelayo u-Excel xa uvavanya idatha kwiseli.

Umzekelo wesinyathelo ngokumanyathelo apha ubeka imithetho emithathu enemibandela yokufomathiza eya kukhangela ukujonga ukuba imihla ifakiwe kwiiyunithi ezikhethiweyo zeeseli zidlulileyo iintsuku ezingama-30, iintsuku ezingama-60 ezedlule, okanye iintsuku ezingama-90 ezedlulileyo.

Iifomula ezisetyenziswe kule mithetho zikhupha inani elithile leentsuku ukusuka ngomhla okhoyo kwiiseli C1 ukuya kwiC4.

Umhla wamanje ubalwa usebenzisa umsebenzi we- TODAY .

Ukuze le khosi isebenze kufuneka ufake imihla ewela kwiiparameters ezibhalwe ngasentla.

Qaphela : I- Excel isebenza ngokufomathiweyo kwimiqathango, ngokuphezulu ukuya phezulu, ukuba imigaqo iboniswe kwibhokisi yencoko yebhokisi yencoko yokuLawula iMigaqo-miselo njengoko iboniswe kumfanekiso ongentla.

Nangona imithetho emininzi ingasebenza kwezinye iiseli, umyalelo wokuqala ohlangabezana nale mqathango usetyenziswa kwiiseli.

02 we-06

Ukuhlolwa kweeNyanga ezingama-30 iintsuku ezidlulileyo

1. Phakamisa iiseli C1 ukuya kwiC4 ukuze ukhethe. Olu luhlu ekuya kuthi sisebenzise imigaqo yokufomatha yomqathango
2. Cofa kwiTebhu yeKhaya yemenyu yebhondi .
3. Cofa iqhosha lokufometha kweMigqaliselo ukuvula imenyu ehlayo.
4. Khetha ukhetho olutsha. Oku kuvulwa kwebhokisi yencoko yebhokisi yencoko ye-Formatting.
5. Cofa usebenzise Ifomula ukukhetha ukuba yeyiphi iiseli ukufomatha ukhetho.
6. Faka le fomyula elandelayo kwibhokisi engezantsi kweempawu zefomathi apho eli xabiso linyaniso okwenyaniso kwisigqibo esingaphantsi kwibhokisi yencoko:
   = TODAY () - C1> 30
   Le fomyula ihlola ukuqinisekisa ukuba imini kwiiseli zeC1 ukuya kwiC4 zingaphezu kweentsuku ezingama-30 ezedlulileyo
7. Cofa iqhosha lokuFometha ukuvula ibhokisi yencoko yebhokisi yefomathi.
8. Cofa u Gcwalisa ithebhu ukuze ubone okukhethwa kukho kombala ozalisekileyo.
9. Khetha umbala ogcwala umgca-ukuze ufanise umzekelo kule tutorial, khetha uhlaza oluhlaza.
10. Cofa kwiTebhu yomxholo ukuze ubone indlela yokwenza ifomathi yefonti
11. Ngaphantsi kwecandelo lombala, setha umbala wefonti ube mhlophe ukulinganisa le khokelo.
12. Cofa Kulungile kabini ukuvala ibhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela.
13. Umbala wemvelaphi weeseli C1 ukuya ku-C4 uya kutshintsha kumbala ozalisiweyo okhethiweyo, nangona kungekho datha kwiiseli.

03 we-06

Ukongeza uMgaqo weeData ezingaphezulu kweentsuku ezingama-60 ezidlulileyo

Ukusebenzisa iMithetho yoLawulo

Esikhundleni sokuphinda onke amanyathelo angentla ukuba angeze imithetho emibini elandelayo, siya kusebenzisa indlela yokuLawula iMigaqo eya kusenza sikwazi ukufaka imithetho eyongezelelweyo ngexesha elilodwa.

1. Phakamisa iiseli C1 ukuya ku-C4, ukuba kuyimfuneko.
2. Cofa kwitheyibhi laseKhaya kwimenyu yebhondi.
3. Cofa kwi icon Yokwenza Ifomenti yokuvula ukuvula imenyu engezantsi.
4. Khetha inketho yokuLawula iMigaqo yokuvula ibhokisi yencoko yebhokisi yencoko yomphathi weMigaqo-nkqubo.
5. Cofa kwiNew Rule inketho kwikhoneni eliphezulu lasekhohlo lebhokisi yencoko
6. Cofa ukusebenzisa i-Formula ukucacisa ukuba yeyiphi iiseli ukufomatha ukhetho kwiluhlu ophezulu kwibhokisi yencoko.
7. Faka le fomyula elandelayo kwibhokisi engezantsi kweempawu zefomathi apho eli xabiso linyaniso okwenyaniso kwisigqibo esingaphantsi kwibhokisi yencoko :
   = TODAY () - C1> 60

   Le fomyula ihlola ukuqinisekisa ukuba imihla ngemihla kwiiC1 ukuya kwiC4 zikhulu kuneentsuku ezingama-60 ezedlule.

8. Cofa iqhosha lokuFometha ukuvula ibhokisi yencoko yebhokisi yefomathi.
9. Cofa u Gcwalisa ithebhu ukuze ubone okukhethwa kukho kombala ozalisekileyo.
10. Khetha umbala ogcwala umgca; ukufanisa umzekelo kule tutorial, khetha uluhlaza.
11. Cofa Kulungile ngokuphindwe kabini ukuvala ibhokisi yencoko kwaye ubuyele kwibhokisi yencoko yebhokisi yencoko yoMphathi weMimiselo.

04 we-06

Ukongeza uMgaqo weeNyanga ezingaphezulu kweentsuku ezingama-90 ezidlulileyo

1. Phinda amanyathelo 5 ukuya ku-7 ngentla ukufaka umgaqo omtsha.
2. Ukusetyenziswa kwefomula:
   = TODAY () - C1> 90
3. Khetha umbala ogcwala umgca; ukufanisa umzekelo kule tutorial, khetha i-orange.
4. Beka umbala wefonti kumhlophe ukuze uhambelane nale khokelo.
5. Cofa Kulungile ngokuphindwe kabini ukuvala ibhokisi yencoko kwaye ubuyele kwibhokisi yencoko yebhokisi yencoko yoMphathi weMimiselo
6. Cofa u- OK kwakhona ukuvala le bhokisi yencoko kwaye ubuyele kwiphepha lokusebenzela .
7. Umbala wemvelaphi weeseli C1 ukuya kwiC4 uya kutshintsha kumbala wokugqibela ozalisiweyo.

05 ka 06

Ukuvavanya iMigaqo yokuFometha kwemiqathango

Njengoko kunokubonwa kumfanekiso wesifundo, sinokuvavanya imigaqo yokufomatha enemiqathango kwiiseli C1 ukuya kwiC4 ngokufaka le mihla elandelayo:

• Umhla okwangoku-iseli kufuneka ishintshe kwimvelaphi emhlophe engapheliyo kunye nombhalo omnyama, kuba akukho mithetho yokufomatha imimiselo esebenzayo.
• Kwiintsuku ezingama-40 phambi komhla okhoyo-iseli kufuneka ishintshe kwindawo eluhlaza eluhlaza kunye nombhalo omhlophe.
  
  (Qaphela: Ukuba unenkathazo yokubala umhla ololo hlobo, njengoko kubonwe kumfanekiso ongentla, ifomula = TODAY () - 40 iya kufaka umhla umhla 40 ngaphambi komhla okhoyo.)
• Kwiintsuku ezingama-70 phambi komhla wamanje-iseli kufuneka ishintshe kwimvelaphu eluhlaza kunye nombhalo omhlophe.
• Kwiintsuku eziyi-100 phambi komhla wamanje-iseli kufuneka ishintshe kwimvelaphi emnyama ebomvu ngombhalo omhlophe.

06 we-06

Imigaqo yokuFomathiza yeMimiselo

Ukuba ishidi lakho lomsebenzi sele libonise umhla okhoyo-kwaye amaninzi ama-worksheth ayenayo-ifom elandelayo kulabo bangasentla angasebenzisa iselfowuni kwiseli apho umhla wamanje uboniswa kunokuba usebenzise umsebenzi we-TODAY.

Ngokomzekelo, ukuba umhla uboniswe kwi-cell B4, ifom yangeniswa njengomgaqo wokumisa imimiselo yeemeko ezingaphezulu kweentsuku ezingama-30 ezidlulileyo ngenxa yokuba:

= $ B $ 4> 30

Iimpawu zeedola (i-dollar) ezungeze isalathiso seeseli B4 zithintela ukuba isalathisi yesithenho ishintshe ukuba umgaqo-fomathi wemeko ukopishwa kwezinye iiseli kwiphepha lokusebenzela.

Iimpawu ze dolali zenza into eyaziwa ngokuba yi- cell reference reference .

Ukuba iimpawu ze dollar ziyekanga kwaye umgaqo-fomathi wemeko ukopishwa, isisele okanye iiseli eziya kubonakala ziza kubonisa i- #REF! umyalezo wephutha.