Guqula idatha yedatha ibe ngamanani ezinombolo
Umsebenzi we-VALUE ku-Excel ungasetshenziselwa ukuguqula izinombolo ezifakelwe njengedatha yombhalo ezilinganisweni zamanani ukuze zisetshenziswe ekubaleni.
Shintsha idatha yombhalo ku-Numeri nge-VALUE Function ku-Excel
Ngokuvamile, i-Excel iguqula ngokuzenzakalelayo idatha yenkinga yalolu hlobo ezinombolweni, ngakho-ke umsebenzi we-VALUE awudingeki.
Kodwa-ke, uma idatha engekho kwifomu evezwa yi-Excel, idatha ingashiywa njengombhalo, futhi, uma kwenzeka lesi simo, imisebenzi ethile, njenge- SUM noma i- AVERAGE , ingayinaki idatha kulawa maseli futhi amaphutha wokubala angenzeka .
I-SUM ne-AVERAGE ne-Data Text
Isibonelo, emgqeni wesihlanu esithombeni ngenhla, umsebenzi we-SUM usetshenziselwa ukuqedela idatha emigqeni emithathu nasemine kokubili kumakholomu A no-B ngemiphumela elandelayo:
- Idatha kumaseli A3 no-A4 ifakiwe njengombhalo ngakho umsebenzi we-SUM kuseli cell A5 uyayigcina le datha futhi ubuyisele umphumela we-zero.
- Emaseleni B3 no-B4, umsebenzi we-VALUE usetshenziselwe ukumboza idatha ku-A3 no-A4 ngezinombolo. Umsebenzi we-SUM esitokisini B5 ubuyisela imiphumela ka-55 (30 + 25).
Ukulungiswa okuzenzakalelayo kwedatha ku-Excel
Idatha yombhalo ozenzakalelayo ihambelana ngakwesobunxele kuseli namanani - kufaka phakathi izinsuku - ngakwesokudla.
Esikhathini, idatha ku-A3 ne-A4 ivumelanisa ngakwesokunxele kweseli ngoba ifakwe njengombhalo.
Emangqamuzaneni B2 no-B3, idatha iguqulwe ukufaka idatha ngokusebenzisa umsebenzi we-VALUE ngakho-ke iqondanisa ngakwesokudla.
I-Syntax ne-Arguments ye-VALUE Function
I- syntax yomsebenzi ibhekisela kokuhlelwa komsebenzi futhi ihlanganisa igama lomsebenzi, amabakaki, nokuphikisana .
I-syntax yomsebenzi we-VALUE yile:
= VALUE (Umbhalo)
Umbhalo - (okudingekayo) idatha okuzoguqulwa ibe yinombolo. Ingxabano ingaqukatha:
- idatha yangempela ehlanganisiwe kumamaki okucaphuna - umugqa wesibili wesibonelo ngenhla;
- ireferensi yeseli endaweni yedatha yombhalo ekhasini lokusebenzela - irowu 3 yesibonelo.
#VALUE! Iphutha
Uma idatha ingenwe njengoba i-Arguments Text ingakwazi ukuhunyushwa njengenombolo, i-Excel ibuyisela i- #VALUE! iphutha njengoba kuboniswe kusibonelo sesishiyagalolunye sesibonelo.
Isibonelo: Guqula umbhalo kuya kuzinombolo nge-VALUE Function
Uhlu olungezansi yizinyathelo ezisetshenziselwa ukungena ku-VALUE umsebenzi B3 kusibonelo ngenhla usebenzisa ibhokisi lengxoxo lomsebenzi.
Ngaphandle kwalokho, umsebenzi ophelele = VALUE (B3) ungabhalwa ngesandla kwiseli lokusebenzela.
Iguqula idatha Yombhalo ukuze Inombolo nge-VALUE Function
- Chofoza kuseli B3 ukuze wenze iseli esebenzayo ;
- Chofoza kuthebhu yefomula yemenyu ye- ribbon .
- Khetha Umbhalo kusuka kubhebhoni ukuze uvule uhlu oluhlehlisiwe lomsebenzi.
- Chofoza ku- VALUE kuhlu ukuze ulethe ibhokisi lengxoxo lomsebenzi.
- Ebhokisini lebhokisi, chofoza ku- Text line.
- Chofoza ku-cell A3 kuspredishithi.
- Chofoza OK ukuze uqedele umsebenzi bese ubuyela ekhasini lokusebenzela
- Inombolo engu-30 kufanele ibonakale esitokisini B3 ehambelana ngakwesokudla kweseli esibonisa ukuthi manje yinani elingasetshenziswa ekubaleni.
- Uma uchofoza ku-cell E1 umsebenzi ophelele = VALUE (B3) ibonakala kwibha yefomula ngaphezulu kwephepha lokusebenzela.
Ukuguqula Izinsuku Nezikhathi
Umsebenzi we-VALUE ungasetshenziselwa ukuguqula izinsuku nezinsuku ngezinombolo.
Nakuba izinsuku nezikhathi zigcinwa njengezinombolo ku-Excel futhi akudingeki ukuba ziguqulwe ngaphambi kokuzisebenzisa ngezibalo, ukushintsha ifomethi yedatha kungenza kube lula ukuqonda umphumela.
Izinsuku zokugcina ze-Excel nezikhathi njengezinombolo ezilandelanayo noma izinombolo ze-serial . Usuku ngalunye inani likhuphuka ngenye. Izinsuku eziyingxenye zifakwe njengezingxenyana zosuku - njenge-0.5 ngesigamu sosuku (amahora angu-12) njengoba kuboniswe kulayini 8 ngenhla.