Yuav Paub
- Nrhiav % ntawm tus lej: Muab tus lej tso rau hauv kab A thiab % hauv kab B. Hauv kab C, sau =(A1B1).
- Nrhiav % ntawm tag nrho: Muab tag nrho rau hauv kab A thiab tus lej ua tiav hauv B. Hauv kab C, sau =(B1/A1).
-
Txuag li %: Siv tus qauv =A1(1-B1). Tus lej qub yog nyob rau hauv A thiab qhov feem pua raug txo los ntawm yog nyob rau hauv B.
Kab lus no piav qhia yuav ua li cas xam ib feem pua hauv Excel siv ntau txoj hauv kev, xws li cov qauv thiab kev tsim qauv. Txoj hauv kev koj ua yog nyob ntawm qhov txiaj ntsig koj xav tau thiab Excel version koj siv. Cov lus qhia npog Excel hauv Microsoft 365, Excel 2019-2007, Excel Online, thiab Excel rau Mac.
Yuav ua li cas xam feem pua hauv Excel
Txawm hais tias tsis muaj cov qauv feem pua hauv Excel, koj tuaj yeem muab tus lej los ntawm ib feem pua ntawm cov qauv siv. Piv txwv li, yog tias koj muaj ib kem uas muaj cov lej thiab xav xam 10% ntawm ib qho ntawm cov lej, nkag mus rau 10% hauv lwm lub xovtooj, thiab tom qab ntawd siv tus qauv siv lub hnub qub raws li tus neeg ua haujlwm sib npaug.
-
Xaiv lub xov tooj khoob uas koj xav kom cov lus teb tshwm. Nkag mus rau qhov sib npaug ntawm kos npe (=) ua raws li qhov qhib kab lus los pib tsim cov qauv.
Hauv Excel rau Mac, koj tsis xav tau kab lus.
Image -
Xaiv lub xovtooj uas muaj tus lej uas koj xav nrhiav 10%.
Image -
Enter an asterisk ().
Image -
Xaiv lub xovtooj uas koj nkag mus 10%.
Image -
Enter a close parenthesis and press Enter. Kev suav tshwm nyob rau hauv lub xov tooj uas tau xaiv.
Piv txwv: Sau 573 rau hauv cell A1 thiab 10% rau hauv cell B1. Luam cov qauv hauv qab no thiab muab tso rau hauv cell C1 los xam 10% ntawm 573:
=(A1B1)
Image -
Tam sim no koj yuav tsum pom qhov feem pua ntawm cov lej tshiab hauv cell C1.
Image
Multiply the Cells in a Kum by the Same Percentage
Koj tuaj yeem xam tag nrho cov lej hauv ib kem sai li qhov feem pua ntawm cov qauv siv tib yam nrog ob peb kauj ruam ntxiv. Piv txwv li, yog tias koj xav xam 7% se rau cov lej hauv kab A thiab tso rau hauv kab C, koj yuav siv txoj hauv qab no:
-
Sau cov lej uas koj xav muab faib los ntawm 7% rau hauv kab A.
Image -
Xaiv Kab B.
Image -
Right-click thiab xaiv Format Cells.
Image -
Xaiv Percentage thiab xaiv OK.
Image -
Enter 7% rau B1.
Image -
Xaiv B1.
Image -
Tshaj mus rau sab xis ntawm kaum sab xis kom txog thaum koj pom Plus kos npe (+). Qhov no yog lub tshuab filling.
Image -
Xaiv tus fill handle/Plus kos npe thiab luag nws cia rau lwm lub hlwb hauv kab B kom luam qhov feem pua rau cov hlwb, ib yam nkaus.
Image -
Xaiv Kab C.
Image -
Right-click thiab xaiv Format Cells.
Image -
Xaiv Number thiab xaiv OK.
Image -
Xaiv tes C1 thiab nkag mus=(A1B1) hauv Excel 2019, 2016, Excel 2013, Excel 2010, Excel 2007 lossis Excel Online.
Enter=A1B1 hauv Excel 2016 rau Mac lossis Excel rau Mac 2011.
Image -
thawj qhov kev xam pom hauv C1.
Image -
Xaiv C1.
Image -
Xaiv tus fill handle/Plus kos npe thiab luag mus rau lwm lub hlwb hauv kab C. Qhov no yuav luam cov qauv piv txwv mus rau lwm lub hlwb thiab cia li suav cov feem pua ntawm tag nrho. tus lej hauv thawj kab.
Image
Yuav Ua Li Cas Pom Qhov Feem Xyuam ntawm Tag Nrho
Lwm txoj kev xaiv yog los xam cov feem pua ntawm tag nrho. Piv txwv li, yog tias koj tab tom sim txuag $ 1, 500 thiab nce txog $ 736 hauv koj tus as khauj, koj yuav xav paub seb feem pua ntawm koj lub hom phiaj koj tau mus txog. Tsis yog muab faib, koj yuav tsum tau siv cov mis los faib.
-
Nkag mus rau tag nrho lub hom phiaj rau hauv ib lub xov tooj. Piv txwv li, sau 1500 rau A1.
Image -
Sau tag nrho rau hnub tim hauv lwm lub xov tooj. Piv txwv li, sau 736 rau B1.
Image -
Xaiv lub xovtooj uas koj xav pom qhov feem pua.
Image -
Nkag mus rau qhov sib npaug thiab qhib kab lus thiab xaiv lub xov tooj ntawm tes uas muaj hnub kawg; hauv qhov piv txwv no, uas yuav yog B1).
Hauv Excel rau Mac, koj tsis tas yuav suav nrog kab lus.
Image -
Hloov rau pem hauv ntej, ces xaiv lub xov tooj ntawm tes uas muaj tag nrho; hauv qhov piv txwv no, nws yuav yog /A1.
Image -
Nkag kaw lus kaw thiab nias Enter.
Hauv Excel rau Mac, koj tsis tas yuav suav nrog kab lus.
Image Koj cov qauv yuav tsum zoo li no:=(B1/A1) hauv Excel 2019, 2016, Excel 2013, Excel 2010, Excel 2007 lossis Excel Online.
Koj cov qauv yuav tsum zoo li no:=B1/A1 hauv Excel 2016 rau Mac lossis Excel rau Mac 2011.
-
Ib tus lej tshwm hauv lub xov tooj uas tau xaiv.
Image -
Right-click the cell and select Format Cells.
Image -
Xaiv Percentage. Kho cov zauv, yog xav tau, ces xaiv OK.
Image Yog tias koj siv Excel Online, xaiv Home, taw rau Number Format thiab xaiv Percentage.
-
Tus feem pua tshwm hauv lub xovtooj.
Image
Hloov tus nqi los ntawm ib feem pua hauv Excel
Yog tias koj xav txo tus nqi los ntawm ib feem pua, Excel tuaj yeem pab. Piv txwv li, tej zaum koj yuav xav txo koj cov khoom noj khoom haus ntawm koj daim ntawv nyiaj txiag los ntawm 17%. Txhawm rau ua li ntawd, koj yuav tsum xam qhov feem pua ntawm kev sib faib thiab rho tawm.
-
Nkag mus rau tus nqi koj xav hloov los ntawm feem pua hauv thawj lub xov tooj. Piv txwv li, sau $200 hauv xov tooj A1.
Image -
Xaiv kab thib ob.
Image -
Right-click the cell and select Format Cells. Xaiv Percentage thiab xaiv OK.
Yog tias koj siv Excel Online, xaiv Home, taw rau Number Format thiab xaiv Percentage.
Image -
Nkag mus rau feem pua ntawm qhov koj xav txo tus nqi qub hauv kab thib ob. Piv txwv li, sau 17% hauv B1.
Image -
Xaiv hauv lub xov tooj thib peb uas koj xav tso saib qhov hloov pauv.
Image -
Rau qhov piv txwv no, tus qauv koj yuav siv yog=A1(1-B1). Cov mis hauv kab lus suav cov feem pua, uas cov seem ntawm cov mis rho tawm ntawm tus nqi qub.
Yuav kom nce tus nqi los ntawm ib feem pua, siv tib lub mis tab sis tsuas yog hloov Plus kos npe (+) nrog kos npe (-).
Image -
Koj yuav tsum pom qhov tshwm sim tom qab nias Enter.
Image
