ʻO kahi pahu he waiwai maikaʻi loa o kekahi helu. Inā loaʻa i kahi helu maikaʻi kekahi modulus maikaʻi. E ʻike ʻoe pehea e helu ai i ka nui o ka pākēnē i Microsoft Excel.
Hālau a ABS
Aia kahi hana kūikawā i kapa ʻia ʻo ABS no ka helu ʻana i ka nui o ka module ma Excel. He maʻalahi loa ka syntax no kēia hana: "ABS (helu)". A i ʻole, hiki i ka ʻōmole ke hana i ke ʻano "ABS (cell_address_with_number)".
I mea e helu ai, i ka mea, i ka loli ʻana o ka helu -8, pono ʻoe e holo i ka laina o nā palapala a i ʻole kekahi o nā mea i kau ʻia ma ka ʻaoʻao, i aneʻa ʻia e like me: "= ABS (-8)".
No ka hoʻoholo ʻana i ka helu ʻana, kaomi i ka pihi ENTER. E like me kāu e ʻike ai, pane aku nei ka papahana me ka waiwai maikaʻi o ka helu 8.
Aia kekahi ala ʻē aʻe e helu ai i ka pākeke. He kūpono ia i kēlā mau mea hoʻohana i hoʻohana ʻole ʻia e mālama i nā ʻano hoʻohālike i ko lākou poʻo. Pākuʻi mākou i ke kaila i kahi e makemake ai mākou e mālama. Kaomi ma ka pihi "Insert Function" e loaʻa ma ka hema o ka pa pākuhi.
Hoʻomaka ka puka Wizard puka. I ka papa inoa e pili ana i laila, pono ʻoe e ʻimi i ka hana a ka ABS, a hōʻike iā ia. E kaomi ma ka pihi "OK".
E wehe ka puka makani hoʻopaʻapaʻa. Hoʻokahi wale nō ka hana a ka ABS - he helu. Hoʻomaopopo mākou iā ia. Inā makemake ʻoe e lawe i kahi helu mai i ka ikepili i mālama ʻia i loko o kēlā me kēia o ka paʻi o ka palapala, a laila kaomi i ka pihi e pili ana i ka ʻākau o ke ʻano hoʻokomo.
Ma hope o kēlā, ua hōʻemi ʻia ka puka makani, a pono ʻoe e kaomi ma ka pūpuna i loaʻa ka helu mai kahi āu e makemake ai e helu i ka pākana. Ma hope o ka helu e hoʻohui ʻia, kaomi hou i ka pihi ma ka ʻākau o ka mahina komo.
E hoʻomaka hou ka puka makani me nā hoʻopaʻapaʻa hana. E like me kāu e ʻike ai, hoʻopiha ʻia ka mahina helu me kahi waiwai. Kaomi ma ka pihi "OK".
Ma hope o kēia, i ka cell i hōʻike ʻia ma mua, ke hōʻike ʻia nei ka waiwai o ka helu āu i koho ai.
Inā loaʻa ka waiwai i ka papaʻaina, a laila e hiki ke kope ʻia i nā ʻōnaehana hana i nā mea ʻē aʻe. No ka hana i kēia, pono ʻoe e kū ma ka ʻaoʻao hema hema o ka pā i loko o ka mea i loaʻa ai ke ʻano, e paʻa ana i ke kaomi i nā kiore, a kau iho i ka lalo o ka papaʻaina. No laila, aia i kēia kolamu i loko o nā pūlaki ke ʻike ka modulo waiwai.
He mea nui ia e ʻike ai e hoʻāʻo ana kekahi mau mea kākau e kākau i kahi leʻaleʻa, e like me ka hana maʻamau ma ka makemakika, ʻo ia hoʻi, | (helu) |, no ka mea, | -48 |. Eia naʻe, ma ka pane aku, ua hewa lākou, no ka mea ʻaʻole maopopo ʻo Excel i kēia syntax.
E like me kāu e ʻike ai, ʻaʻohe mea paʻakikī i ka helu ʻana i kahi pahu mai kekahi helu ma Microsoft Excel, ʻoiai ua hana ʻia kēia hana me ka hana maʻalahi. ʻO ke ʻano wale nō e pono ai ʻoe e ʻike i kēia hana.
