Indlela yokubala imodyuli kwi-Excel

Ukusebenza "kwi-Excel", unokwenza imisebenzi emininzi eyahlukeneyo, kubandakanya izibalo. Iseti ephakamileyo yezixhobo ziyakuvumela ukuba wenze izenzo ezifunekayo ezingadingi izicelo ezingaphezulu. Enye yale mi sebenzi imodyuli - kwi-Excel ayisebenzisi rhoqo, kodwa inenjongo ebalulekileyo.

Yiyiphi imodyuli

Ngenkcazo, imodyuli isenzo seemathematika esibuyisela inani elipheleleyo leenombolo, oko kukuthi, inamba ngokwayo ngaphandle kwesaziso sayo. Nangona kunjalo, ukusetyenziswa komxinwa kungabonwa kuphela ekuxazululeni iingxaki zeemathematika, kodwa nakwiimodeli zezoqoqosho, i-physics kunye nezinye ezininzi zezesayensi.

Unokubala njani imodyuli kwi-Excel?

Ukuze ubale imodyuli kwi-Excel, ungasebenzisa iindlela ezininzi, elula kunazo zonke umsebenzi we-ABS. Ibuyisa inani elipheleleyo leenombolo ezikhethiweyo okanye isibalo semathematika.

I-syntax yomsebenzi we modyuli ilula kakhulu - kwi-Excel kufuneka nje ucacise ifomula "= ABS" kumgca wefomula, ngoko kuba ngabazali baxela ingxabano enokuba yinombolo, isalathiso kwiseli, kunye neminye imisebenzi ebuyisela inani lenani. Unokwenza lo msebenzi ngokucindezela inkinobho ethi "Faka umsebenzi", apho unokukhetha khona umsebenzi ofanelekileyo okanye ngokukhangela usebenzisa igama "imodyuli" okanye "ABS".

Ukubala inani lemodyuli

Enye yezona zinto ziqhelekileyo kwi-Excel yintlawulo ye-modulo. Ikuvumela ukuba ungeze ixabiso leeseli ngaphandle kokuqwalasela uphawu lwabo. Ukuze wenze le nyathelo, akudingeki ukuba uqale ubale imodyuli yenani ngalinye, uze usebenzise umsebenzi wokugqibela.

Xa wenza umsebenzi ohambelana namaxabiso amaninzi, imodyuli kwi-Excel inokusebenza ngexesha elifanayo kunye nesethi yonke okanye uluhlu lweeseli. Ngaloo ndlela, ukubala i-modulo yesantya, kwanele ukusebenzisa ukwakhiwa kweemfuno ezilandelayo:

= ISUM (ABS (A1: A4))

Apha kwikholam A, imigca emine yokuqala ibonisa ixabiso ofuna ukuyongeza i-modulo.

U mzekelo

Ukudibanisa ukuqonda kwenkcazo yemodyuli kwi-Excel kunye nemigaqo yokusebenza kwayo, kuyafaneleka ukuqwalasela imizekelo emibini elula ebonisa ukusebenza komsebenzi.

Ukubala i-modulus yenani elinikeziweyo okanye umzekelo weemathematika, umzekelo umehluko 2 no-5, sebenzisa oku kungenayo:

= ABS (2-5)

Isiphumo sale mibuzo siyinombolo "3".

Ukuba ngaba ufuna ukubala isantya seempawu ze-matrix ezinokubhaliweyo ezibhalwe kwitheyibhile, kunye ne-A1: C3, indlela ekhawulezayo yokufumana impendulo ukuyila:

= ISUM (ABS (A1: C3))