Shandura dhidhiyo yedhidhi muzvidimbu zvekuverenga
Iko VALUE basa mu Excel inogona kushandiswa kushandura nhamba dzakapinda semashoko ekunyora mumatare ezvinyorwa kuitira kuti dzigone kushandiswa mukuverenga.
Shandura Text Data kuNumeri pamwe ne VALUE Function mu Excel
Kazhinji, Excel inoshandura pachedu dambudziko rekutevedzera kwemaitiro aya kumatare, saka VALUE basa haifaniri.
Zvisinei, kana data isiri mumutauro iyo Excel inoziva, data inogona kusara semashoko, uye, kana izvi zvikaitika, mamwe mabasa , akadai SUM kana AVERAGE , haazofariri dhenda iri mumaseli uye zvikanganiso zvekuverenga zvinogona kuitika .
SUM uye AVERAGE uye Text Data
Somuenzaniso, mumutsara wechishanu mumufananidzo wepamusoro, basa reSUM rinoshandiswa kukwana data iri mumitsara mitatu nemana mumakoroni maviri A uye B nemigumisiro inotevera:
- Dhiyabhorosi iri mumasero A3 neA4 akange aiswa semashoko kuitira kuti basa reSUM muchitokisi A5 riremekedze iyi data uye rinodzorera mhinduro ye zero.
- Mumasero B3 neB4, basa re VALUE rakashandiswa kuvhara data iri muA3 neA4 muzviverengero. Basa reSUM muchitokisi B5 rinodzorera mhinduro ye 55 (30 + 25).
The Default Alignment of Data in Excel
Nekutadza kudhindwa kwemashoko manotsi kune kuruboshwe mumusero uye nhamba - kusanganisira mazuva - ari kurudyi.
Mumuenzaniso, data iri muA3 neA4 yakanamatira kune rumwe rutivi rworuboshwe rwesero nekuti rwakapinda seirima.
Mumasero B2 neB3, data yakashandurwa kuverenga data vachishandisa VALUE basa uye naizvozvo inowirirana kurudyi.
Iko VALUE Function ya Syntax uye Arguments
Mutsara webasa unoreva kurongeka kwebasa uye rinosanganisira zita rebasa, mabheji, uye nharo .
Mutsara we VALUE basa ndewokuti:
= VALUE (Magwaro)
Mhemberero - (inodikanwa) data inoshandurwa kuchinhamba. Nharo yacho inogona kuva:
- iyo chaiyo data inowanikwa muzvinyorwa zvinyorwa-mutsara 2 wemuenzaniso uri pamusoro;
- sero rinotarisa kune nzvimbo yemashoko ekunyora mubhuku remabasa - rutsara 3 rwemuenzaniso.
#VALUE! Mhosva
Kana iyo inopinda seMagwaro argument haigone kududzirwa se nhamba, Excel inodzorera #VALUE! kukanganisa sezvinoratidzwa mumutsara wepfumbamwe wemuenzaniso.
Muenzaniso: Shandura Rugwaro kuNhamba pamwe ne VALUE Function
Zvinyorwa pasi apa ndezvikwiriso zvinoshandiswa kupinda mu VALUE basa B3 mumuenzaniso uri pamusoro uchishandisa bhokisi rebasa rebasa.
Zvimwe, iyo yakakwana basa = VALUE (B3) inogona kuiswa manyore muchikwereti chebasa.
Kuchinja Nhamba Dheyo Dhamba kuNhamba pamwe ne VALUE Function
- Dzvanyira pane sero B3 kuti riite iro rinoshanda sero ;
- Dzvanya paMafomu yebhu yebhoni yebhoni .
- Sarudza Rugwaro kubva kubhoni kuti uzarure basa rinoderera pasi.
- Dzvanya pa VALUE murugwaro kuti ubudise bhokisi rebasa rebasa.
- Mubhokisi rebhokisi, chengeta paMagwaro .
- Dzvanya pane sero A3 mune pepanheti.
- Dzvanya OK kuti upedze basa uye dzokera kushizha rekushanda
- Nhamba ye30 inofanirwa kuonekwa muchitokisi B3 yakatarisana nechokurudyi chesero chinoratidza kuti ikozvino kukosha kunogona kushandiswa mukuverenga.
- Paunenge uchibvisa pane cell E1 zvakakwana basa = VALUE (B3) inowanikwa mubhadha yepamusoro pane pepa rekushanda.
Kuchinja Mazuva Nenguva
Iko VALUE basa inogona kushandiswa kushandura mazuva uye nguva kune nhamba.
Kunyange zvazvo mazuva uye nguva dzakachengetwa se nhamba kuExcel uye hapana chikonzero chekuzvishandura vasati vashandise pakuverenga, kuchinja mafomu epa data kunogona kuita kuti zvive nyore kunzwisisa chigumisiro.
Zuva rekutengesa mabhizinesi uye dzimwe nguva sezviverengero zvakaenzana kana nhamba dze serial . Zuva roga roga nhamba inowedzera neyese. Mazuva akatsaurwa anopinda sezvikamu zvezuva - zvakadai se3,5 kwehafu yezuva (maawa 12) sezvinoratidzwa mundima 8 pamusoro.