Chikamu chesvomhu uye chetrigonometric chine mabasa anosvika makumi masere akasiyana eExcel, kubva pakukosha kupfupisa uye kutenderedza, kusvika kunhamba isingazivikanwe yetrigonometric mabasa. Sechikamu chechidzidzo ichi, tichaongorora chete anonyanya kubatsira masvomhu mabasa muExcel.
Pamusoro pemabasa emasvomhu SUM и SUMMESLI Unogona kuverenga muchidzidzo ichi.
RUNDZO()
basa remasvomhu ROUNDWOOD inobvumidza iwe kutenderedza kukosha kune inodiwa nhamba yenzvimbo dzedesimali. Unogona kudoma nhamba yenzvimbo dzedesimali munharo yechipiri. Mumufananidzo uri pazasi, fomula inotenderedza kukosha kunzvimbo imwe yedesimali:
Kana nharo yechipiri iri zero, saka basa rinotenderedza kukosha kune iri pedyo nhamba yakazara:
Nharo yechipiri inogonawo kuve isina kunaka, mune iyo mamiriro kukosha kunotenderedzwa kune inodiwa decimal point:
Nhamba yakaita se231,5 ibasa ROUNDWOOD kutenderera kubva ku zero:
Kana iwe uchida kutenderedza nhamba kumusoro kana pasi mukukosha kwakakwana, unogona kushandisa mabasa KRUGLVVERH и DZONDE PASI.
PRODUCT()
basa remasvomhu PRODUCT inoverenga chibereko chenharo dzayo dzose.
Isu hatisi kuzokurukura nezvebasa iri zvakadzama, sezvo rakanyanya kufanana nebasa racho SUM, musiyano uri muchinangwa chete, mumwe anopfupikisa, wechipiri anowedzera. Mamwe mashoko pamusoro SUM Unogona kuverenga chinyorwa Sum muExcel uchishandisa iyo SUM uye SUMIF mabasa.
ABS()
basa remasvomhu ABS inodzorera kukosha kwakakwana kwenhamba, kureva module yayo.
basa ABS inogona kubatsira pakuverenga nhamba yemazuva pakati pemazuva maviri, kana pasina nzira yekuziva kuti nderipi zuva rekutanga uye nderipi magumo.
Mumufananidzo uri pazasi, makoramu A neB anomiririra misi, uye ndeipi pairi yekutanga uye nderipi zuva rekupedzisira harizivikanwe. Zvinotarisirwa kuverenga mazuva pakati pemazuva aya. Kana iwe ukangobvisa rimwe zuva kubva kune rimwe zuva, saka huwandu hwemazuva hunogona kuve husina kunaka, izvo zvisiri izvo zvachose:
Kuti tidzivise izvi, tinoshandisa basa ABS:
Kudzvinyirira pinda, tinowana nhamba chaiyo yemazuva:
MUDZI()
Inodzosa square root yenhamba. Nhamba yacho inofanira kunge isiri-negative.
Iwe unogona zvakare kubvisa skweya midzi muExcel uchishandisa exponentiation opareta:
DEGREE()
Inokubvumira kukwidza nhamba kune simba rakapiwa.
MuExcel, mukuwedzera kune iri basa remasvomhu, unogona kushandisa exponentiation opareta:
CASEBETWEEN()
Inodzosa nhamba isina kurongeka pakati pezvinhu zviviri zvinopihwa senharo. Pese pese pepa parinoverengerwa, kukosha kunovandudzwa.
Kunyangwe kune akawanda emabasa emasvomhu muExcel, mashoma chete ndiwo akakosha chaiwo. Hapana chikonzero chekudzidza zvese panguva imwe chete, sezvo zvakawanda zvingasatombobatsira. Mabasa emasvomhu anotsanangurwa muchidzidzo ichi ndiwo mashoma ayo anovimbisa kushanda nechivimbo muExcel uye haazoremedze ndangariro yako neruzivo rusina basa. Rombo rakanaka uye kubudirira mukudzidza Excel!