Inā ua hana ʻoe ma Excel, ua hoʻohana paha ʻoe iā ia no ka mālama ʻana a me ka helu ʻana i nā ʻano ʻikepili like ʻole, e like me nā helu helu, decimals, a me nā pākēneka. Eia nō naʻe, pono paha ʻoe e hana ma Excel me nā waiwai i ke ʻano nā hakina maʻamauE like me 1/2 (hoʻokahi kekona) a i ʻole 2/3 (ʻelua hapakolu), me ka hoʻololi ʻole i nā hakina decimal.
No ka laʻana, loaʻa iā mākou kahi meaʻai no nā kuki kīkī kokoleka a makemake mākou e hōʻano ma Microsoft Excel. Pono ka meaʻai i mea hoʻohui - 1/4 teaspoon paʻakai, pono e kākau ʻia ma ke kolamu B, ma ke ʻano he hakina maʻamau.
Ma mua o ka hoʻomaka ʻana e hoʻokomo i nā mea ʻai, pono mākou e hoʻololi i kekahi mea i kā mākou papaʻaina. E like me kāu e hoʻomanaʻo ai (me kā mākou mau haʻawina), hiki iā ʻoe ke hoʻopili i ka hoʻopono kūikawā i kekahi kelepona ma Excel, ʻo ia hoʻi ka ʻano helu. Loaʻa iā Excel kahi ʻano helu fractional e hiki ai iā ʻoe ke hoʻokomo i nā waiwai ma ke ʻano he mau hakina. No ka hana ʻana i kēia, hōʻike mākou i ka kolamu B a laila ma ka pā Home (Home) ma ka papa inoa hāʻule iho Hōʻike Helu (Helu helu) koho i ka mea Kaulana (Minor).
E ʻoluʻolu e hana mākou ma Excel 2013 i kēia hiʻohiʻona, akā e hana kēia ʻano hana ma Excel 2010 a me 2007 ma ke ʻano like. No Excel 2003 a ma mua, e koho i nā cell i makemake ʻia a kaomi i ka pōkole keyboard CTRL+1e hoʻonohonoho i ke ʻano helu. E ʻoluʻolu, ʻaʻole i loaʻa kēia koho ma Google Sheets.
I kēia manawa ua hoʻonohonoho ʻia ka ʻano helu, ua mākaukau mākou e hoʻokomo i nā hakina ma ke kolamu B.
E hoʻomaopopo he hiki ke hōʻike ʻia nā helu ma ke ʻano he mau hakina hui ʻia, ma ke ʻano 2 3 / 4 (ʻelua a ʻekolu hapahā). Inā koho ʻoe i kekahi o kēia mau cell, e ʻike ʻoe ma ka papa formula e mālama maoli ʻo Excel i kēlā mau waiwai ma ke ʻano he decimals - ke hoʻololi wale nei ke ʻano o ka hakina i ka hōʻike ʻana o ka helu i loko o ke kelepona. ʻo kahi laʻana, 2 3 / 4 ua like ia me 2.75.
Hiki iā ʻoe ke hoʻohana i nā hakina maʻamau i nā formula a me nā hana. E noʻonoʻo e pili ana kēia meaʻai no ʻelua mau ʻāpana kuki. Inā pono ʻoe e hana i ʻehā mau kuki, hiki iā ʻoe ke pāpālua i ka ʻai me ka Excel. Inā pono mākou e pāpālua i ka nui o ka paʻakai i loko o kahi meaʻai, pono mākou e hoʻonui i ka waiwai o ka cell B2 ma 2; e like ana ke kumu penei: = B2 * 2. A laila hiki iā mākou ke kope i ke ʻano i nā cell ʻē aʻe i ke kolamu C ma ke koho ʻana i ke kelepona a kauo i ka lima hoʻopiha piha.
Loaʻa iā mākou nā waiwai fractional hou no kā mākou papa ʻai pālua! E like me kāu e ʻike ai, ʻoi aku ka maʻalahi o ka hoʻohana ʻana i kēlā ʻano helu helu ma Excel i ka hana me nā hakina, ʻoiai inā ʻaʻole ʻoe makemake e hoʻololi i nā hakina maʻamau i decimals.