Sinthani deta yamasamba muzinthu zamtengo
Ntchito VALUE mu Excel ingagwiritsidwe ntchito kusintha manambala omwe alowedwa ngati deta yolembedwa muzinthu zamtengo wapatali kotero kuti angagwiritsidwe ntchito powerengera.
Sinthani Deta Zamtundu kuti Muwerengere ndi VALUE Function mu Excel
Kawirikawiri, Excel imasinthira deta yamtundu wotere mwa nambala, choncho ntchito VALUE siyenela.
Komabe, ngati deta siyiyi yomwe Excel imazindikira, deta ingasiyidwe ngati malemba, ndipo, ngati izi zikuchitika, ntchito zina, monga SUM kapena AVERAGE , zidzanyalanyaza deta mu maselowa ndi zolakwika zikhoza kuchitika .
SUM ndi AVERAGE ndi Text Text
Mwachitsanzo, mu mzere wachisanu pa chithunzi pamwambapa, ntchito ya SUM imagwiritsidwa ntchito polemba zonsezi m'mizere itatu ndi inayi muzitsulo A ndi B ndi zotsatira izi:
- Deta m'maselo A3 ndi A4 alowetsedwa ngati momwe ntchito ya SUM mu selo A5 imanyalanyaza deta iyi ndipo imabweretsa zotsatira za zero.
- Mu maselo B3 ndi B4, ntchito VALUE yagwiritsidwa ntchito kutseka deta mu A3 ndi A4 muzinthu. Ntchito ya SUM mu selo B5 imabweretsa zotsatira za 55 (30 + 25).
Kusinthika Kwadongosolo kwa Data mu Excel
Dongosolo lachinsinsi la malemba likugwirizana kumanzere mu selo ndi manambala - kuphatikizapo masiku - kumanja.
Mu chitsanzo, deta mu A3 ndi A4 ikhale mbali ya kumanzere kwa selo chifukwa yalembedwera monga malemba.
M'maselo B2 ndi B3, deta yasinthidwa kuti iwerengetse deta pogwiritsa ntchito VALUE ntchito ndipo imagwirizanitsa kumanja.
Syntax ndi Funso la Function
Syntax ya ntchito imatanthawuza momwe ntchitoyo ikuyendera ndipo imaphatikizapo dzina la ntchito, mabaki, ndi zifukwa .
Chidule cha ntchito VALUE ndi:
= VALUE (Malemba)
Malemba - (oyenerera) deta kuti ikhale nambala. Kukangana kungakhale ndi:
- deta yomwe ili mkati mwa zizindikiro zotsatsa - mzere 2 wa chitsanzo pamwambapa;
- selo lotanthauzira za malo a zolemba zomwe zili pamsewu - gawo lachitatu la chitsanzo.
#VALUE! Cholakwika
Ngati deta inaloledwa ngati ndemanga ya Malemba silingatanthauzidwe ngati nambala, Excel imabweretsanso #VALUE! zolakwika monga momwe zasonyezedwa mu mzere wachisanu ndi chinayi cha chitsanzo.
Chitsanzo: Sinthani Malemba ku Numeri ndi Ntchito VALUE
Mndandanda womwe uli pansipa ndi njira zomwe zimagwiritsidwa ntchito kulowa VALUE ntchito B3 muchitsanzo pamwamba pogwiritsa ntchito bokosi la bokosi .
Mwinanso, ntchito yonse = VALUE (B3) ingalembedwe mwapadera mu selo lamasewera.
Kutembenuza Malemba Deta Kuti Muwerengere ndi Ntchito VALUE
- Dinani pa selo B3 kuti mupange selo yogwira ntchito ;
- Dinani pa Fomu tab ya menyu yowonjezera.
- Sankhani Mawu kuchokera ku kaboni kuti mutsegule ntchito yolemba pansi.
- Dinani pa VALUE m'ndandanda kuti mubweretse bokosi lazokambirana.
- Mu bokosi la bokosi, dinani palemba mzere.
- Dinani pa selo A3 mu spreadsheet.
- Dinani OK kuti mukwaniritse ntchitoyi ndi kubwerera kuntchito
- Nambala 30 iyenera kuoneka mu selo B3 yomwe ikugwirizana ndi mbali yeniyeni ya selo yomwe ikuwonetsa kuti tsopano ndi mtengo umene ungagwiritsidwe ntchito powerengera.
- Mukasindikiza pa selo E1 ntchito yonse = VALUE (B3) ikuwonekera pa bar barolomu pamwamba pa tsamba.
Kusintha Nthawi ndi Nthawi
Ntchito VALUE ingagwiritsidwenso ntchito kutembenuza masiku ndi nthawi ku nambala.
Ngakhale masiku ndi nthawi zikusungidwa ngati nambala mu Excel ndipo palibe chifukwa chosinthira musanazigwiritse ntchito pakuwerengera, kusintha mawonekedwe a deta kungakhale kosavuta kumvetsa zotsatira.
Maofesi a Excel amatha nthawi ndi nthawi ngati nambala zowerengeka kapena manambala amodzi . Tsiku lililonse chiwerengero chikuwonjezeka ndi chimodzi. Masiku osankhidwa amalowa ngati magawo a magawo a tsiku - monga 0.5 kwa theka la tsiku (maola 12) monga momwe tawonedwera mzere 8 pamwambapa.