Nau'in lissafi da trigonometric ya ƙunshi kusan ayyuka 80 daban-daban na Excel, kama daga taƙaitawa da zagaye da ba makawa, zuwa ƙaramin sanannun adadin ayyukan trigonometric. A matsayin wani ɓangare na wannan darasi, za mu sake nazarin ayyukan lissafi mafi amfani kawai a cikin Excel.
Game da ayyukan lissafi SUM и SUMMESLI Kuna iya karantawa a cikin wannan koyawa.
ZAGAYA()
aikin lissafi ROUNDWOOD yana ba ku damar zagaye ƙimar zuwa adadin da ake buƙata na wuraren goma. Kuna iya tantance adadin wuraren ƙima a cikin mahawara ta biyu. A cikin hoton da ke ƙasa, dabarar tana zagaye darajar zuwa wuri ɗaya na ƙima:
Idan hujja ta biyu sifili ne, to aikin yana zagaye darajar zuwa lamba mafi kusa:
Hujja ta biyu kuma tana iya zama mara kyau, wanda a halin da ake ciki ana zagayawa darajar zuwa madaidaicin ƙima.
Lamba kamar 231,5 aiki ne ROUNDWOOD zagaye nesa da sifili:
Idan kana buƙatar zagaye lamba sama ko ƙasa da cikakkiyar ƙima, zaka iya amfani da ayyukan KRUGLVVERH и ZAGAYA KASA.
PRODUCT()
aikin lissafi PRODUCT yana ƙididdige samfurin duk hujjojinsa.
Ba za mu tattauna wannan aikin dalla-dalla ba, tun da yake yana kama da aikin SUM, Bambanci shine kawai a cikin manufar, daya taƙaita, na biyu ya ninka. Karin bayani game da SUM Kuna iya karanta labarin Sum a cikin Excel ta amfani da ayyukan SUM da SUMIF.
ABS()
aikin lissafi ABS yana dawo da cikakkiyar ƙimar lambar, watau tsarin sa.
aiki ABS zai iya zama da amfani yayin ƙididdige adadin kwanakin tsakanin kwanakin biyu, lokacin da babu yadda za a iya tantance wane kwanan wata ne farkon kuma wane ne ƙarshen.
A cikin wannan adadi da ke ƙasa, ginshiƙan A da B suna wakiltar kwanakin, kuma wanene farkon su kuma wane ne kwanan wata na ƙarshe ba a sani ba. Ana buƙatar ƙidaya adadin kwanakin tsakanin waɗannan kwanakin. Idan kawai ka cire wani kwanan wata daga kwanan wata, to adadin kwanakin na iya zama mara kyau, wanda ba daidai ba ne:
Don guje wa wannan, muna amfani da aikin ABS:
Dannawa Shigar, muna samun daidai adadin kwanakin:
Tushen()
Yana dawo da tushen murabba'in lamba. Dole ne lambar ta zama mara kyau.
Hakanan zaka iya cire tushen murabba'in a cikin Excel ta amfani da ma'aikacin tsawaitawa:
digiri()
Yana ba ku damar ɗaga lamba zuwa ikon da aka bayar.
A cikin Excel, ban da wannan aikin lissafi, zaku iya amfani da afaretan fassarar:
KASASHEN ()
Yana dawo da lamba bazuwar tsakanin ƙimar biyu da aka bayar azaman mahawara. Duk lokacin da aka sake kirga takardar, ana sabunta ƙimar.
Ko da yake akwai ayyuka da yawa na lissafi a cikin Excel, kaɗan ne kawai daga cikinsu ke da ƙima na gaske. Babu ma'ana a koyan komai lokaci guda, tunda da yawa ba za su yi amfani ba. Ayyukan lissafin da aka kwatanta a cikin wannan darasi sune mafi ƙanƙanta waɗanda za su tabbatar da aiki mai ƙarfin gwiwa a cikin Excel kuma ba za su cika ƙwaƙwalwar ajiyar ku tare da bayanan da ba dole ba. Sa'a da nasara a cikin koyon Excel!