Maitiro Ekuwedzera Kunzana Macart

Anonim

Kuwanza iyo nhamba muzana muMicrosoft Excel

Paunenge uchiita zvakasiyana-siyana kuverenga, dzimwe nguva zvinodikanwa kuwandisa huwandu hwenzvimbo muzana kukosha. Semuenzaniso, iyi kuverenga inoshandiswa mukusarudza iyo huwandu hwekutengeserana kwekutengesa mumari, ine muzana inozivikanwa yehuwandu hwekubvumidzwa. Nehurombo, kwete kune mumwe nemumwe mushandisi ibasa riri nyore. Ngatione kuti tingawanei nhamba yenhamba muMicrosoft Excel application.

Kuwedzera kwehuwandu hwehuwandu muzana

Muchokwadi, iyo muzana chikamu chimwe chikamu chehuwandu hwehuwandu. Ndokunge, pavanoti, semuenzaniso, vashanu vakawanda ne13% - yakafanana ne5 yakawedzerwa neiyo nhamba 0.13. Muchirongwa cheEncel, chirevo ichi chinogona kunyorwa se "= 5 * 13%". Kuti uverenge, kutaura uku kunofanirwa kunyorwa kune tambo yekufungidzira, kana muchitokisi chero papepa.

Iyo yekuwandisa formula yehuwandu muzana muzana muMicrosoft Excel Chirongwa

Kuti uone mhedzisiro muchitokisi chakasarudzwa, ingo tinya bhatani rePeturu pane komputa keyboard.

Mhedzisiro yekuwandisa yehuwandu muzana muzana muMicrosoft Excel Chirongwa

Munzira imwe cheteyo, iwe unogona kuwedzera kuwanda kune iyo seti yetatu yeTabular data. Kune izvi, tinova sero panowanikwa mhedzisiro yekuverenga icharatidzwa. Zvakakodzera zvingave kuti sero iri iri mumutsara mumwechete sehuwandu hwekuverenga. Asi uku hakusi kwekutanga. Isu tinoisa muchitokisi ichi chiratidzo chekuenzana ("="), uye tinya pachiteshi, icho chine nhamba yenhamba. Zvadaro, isa chiratidzo chakawanda (""), uye tora kukosha muzana pane kabhodhi pane iyo yaunoda kuwanda nhamba. Pakupera kwekodhi, usakanganwa kuisa chikamu chezana ("%").

Iyo yekuwandisa formula yehuwandu muzana muzana muMicrosoft Excel chirongwa patafura

Kuti ubudise mhedzisiro pane peji bhatani pane iyo Enter bhatani.

Mhedzisiro yekuwanza yehuwandu muzana muzana muMicrosoft Excel chirongwa patafura

Kana zvichidikanwa, ichi chiito chinogona kuiswa kune mamwe maseru kuburikidza nekungotevedzera formula. Semuenzaniso, kana iyo data iri patafura, zvakwana kungopinda mukona yepazasi yechitokisi, apo iyo formula inotungamirirwa, uye apo mbeva yekuruboshwe ichipika, ikaita pasi kusvika kumagumo tafura. Saka, formula ichayirirwa kumasero ese, uye haina kudikanwa kutyaira inoda kuverenga huwandu hwehuwandu hwehuwandu kune yakatarwa chikamu muzana.

Kutevedzera kuwanda kwekuwedzera mafomu efoni muzana muMicrosoft Excel chirongwa patafura

Sezvauri kuona, nekuwanza iyo nhamba yenhamba muMicrosoft Excel chirongwa, hapana kana matambudziko akakosha kwete chete kune vashandisi vane ruzivo, asi kunyange Newbies. Gwara iri rinokutendera kuti udzidze maitiro aya pasina chero matambudziko.

Verenga zvimwe