Munguva yekuverenga, dzimwe nguva zvinodikanwa kuti uwedzere kufarira kune imwe nhamba. Semuenzaniso, kudzidza zviratidzo zvacho zvinowanikwa, izvo zvinowedzera neyakaenzana muzana zvichienzaniswa nemwedzi wekupedzisira, zvakakosha kuti uwedzere iyi muzana kuhukuru hwemubhadharo wemwedzi wapfuura. Pane mimwe yakawanda mimwe mienzaniso kana iwe uchifanira kuita zvakafanana chiito. Ngatifungei kuti sei kuwedzera muzana muzana kuhuwandu muMicrosoft Excel.
Komputa zviito muchitokisi
Saka, kana iwe uchingoda kuziva kuti nhamba yacho ichaenzana here, mushure mekuwedzera kweimwe muzana yezana, inotevera chero sero rebepa, kana mune yefomati tambo, kutyaira kutaura maererano neyekutevera template: "= (nhamba) + (nhamba) * (kukosha_Procerant)%."
Ngatiti isu tinofanirwa kuverenga nhamba yei yavachiona kana iwe ukawedzera kusvika pa140 muzana. Isu tinonyora pasi inotevera formula muchitokisi chero chipi zvacho, kana mune formula tambo: "= 140 + 140 * 20%".
Tevere, tinya pane iyo Enter bhatani pane iyo khibhodi, uye tinotarisa mhedzisiro.
Kushandiswa kwe formula yekuita patafura
Zvino, ngationgororei nzira yekuwedzera imwe muzana kune data iyo yatove iri patafura.
Chekutanga pane zvese, sarudza sero panowanikwa mhedzisiro icharatidzwa. Isu tinoisa mariri chiratidzo "=". Tevere, tinya pachiteshi chine data iyo iyo iyo muzana inofanirwa kuwedzerwa. Isa chiratidzo "+". Zvekare, nekudzvanya pasero zvine nhamba, isa chiratidzo "*". Tevere, isu tinonyora kukosha muzana pane iyo kabhodhi iyo iyo nhamba yacho iyo iyo nhamba yacho. Usakanganwa mushure mekupinda iyi kukosha kuisa chiratidzo "%".
Dzvanya pane iyo Enter bhatani pane iyo keyboard, mushure iyo mhedzisiro yekuverenga icharatidzwa.
Kana iwe uchida kugovera iyi formula kune ese column tsika patafura, wobva wangove pasi chairo rutivi rwechitokisi panoguma zvaitika. Iyo inotuka inofanirwa kushanduka kuita muchinjikwa. Isu tinodzvanya pane iyo kuruboshwe bhatani bhatani, uye ne "tambanudza" iyo fomula pasi kusvika kumagumo etafura.
Sezvauri kuona, mhedzisiro yekuwandisa yenhamba kune imwe muzana muzana inotorwa mamwe masero ari mukoramu.
Takaona kuti kuwedzera iyo muzana kune iyo nhamba muMicrosoft Excel chirongwa haina kuoma. Zvakangodaro, vashandisi vazhinji havazivi maitiro ekuzviita, uye vanokanganisa. Semuenzaniso, chikanganiso chakajairika ndechekunyora kweiyo formula maererano nea algorithm "= (nhamba) + (propropertrant)%", nhamba) (nhamba) * (kukosha) * (kukosha)%. " Iri bhuku rinofanira kubatsira kudzivirira zvikanganiso zvakadaro.