Rho tawm cov paj laum los ntawm tus lej thaum lub sij hawm lej ntawm kev ua lej tsis yog yam tsawg. Piv txwv, hauv cov tsev lag luam luam tawm qhov feem pua ntawm VAT los ntawm tag nrho cov nyiaj kom thiaj li teev tus nqi ntawm cov khoom uas tsis muaj VAT. Qhov no yog ua los ntawm ntau lub koom haum ntxawg. Cia peb thiab peb xam seb yuav rho pes tsawg feem pua ntawm tus naj npawb hauv Microsoft Excel.
Feem ntau rho tawm hauv kev ua haujlwm zoo
Ua ntej tshaj plaws, cia saib seb qhov feem pua rho tawm tau pes tsawg ntawm tus lej. Yuav rho tawm qhov feem pua ntawm tus naj npawb, koj yuav tsum txiav txim siab tam sim ntawd seb pes tsawg hauv cov nqe lus yuav ua rau ib feem pua ntawm cov naj npawb no. Ua li no, muab cov zauv los ntawm qhov nqi ntawm tus nqi. Tom qab ntawd, qhov tshwm sim yog rho tawm los ntawm thawj tus naj npawb.
Hauv tsab ntawv ntawm Excel, nws yuav zoo li no: "= (naj npawb) - (naj npawb) * (feem pua tus nqi)%".
Peb nthuav qhia qhov sib cais ntawm kev txaus siab rau ib qho piv txwv. Xav tias peb yuav tsum rho 12% ntawm tus naj npawb 48. Tshawb ntawm txhua lub xovtooj ntawm daim ntawv, lossis ua qhov nkag rau hauv qhov formula formula: "= 48-48 * 12%."
Ua ib qho kev xam thiab pom qhov tshwm sim, nyem rau ntawm ENTER khawm ntawm cov keyboard.
Rho tawm kev txaus siab los ntawm lub rooj
Tam sim no cia peb txiav txim seb yuav rho tawm qhov feem pua ntawm cov ntaub ntawv uas tau teev tseg hauv lub rooj.
Yog tias peb xav rho qee feem ntawm tag nrho cov hlwb hauv kab ntawv, ces, ua ntej tshaj plaws, peb los ua tus tshaj plaws hauv xov tooj ntawm lub rooj. Peb muab tso rau hauv nws lub kos npe "=". Ntxiv mus, nyem rau ntawm tes, qhov feem pua ntawm qhov yuav tsum tau rho tawm. Tom qab ntawd, muab kos rau "-", thiab nias dua rau ntawm tib lub cell, uas tau nias ua ntej. Peb muab qhov kos npe "*", thiab los ntawm cov keyboard peb ntaus nqi ntawm feem pua, uas yuav tsum tau rho tawm. Thaum kawg muab qhov kos npe "%".
Peb nias rau ntawm ENTER khawm, tom qab ntawd, cov lus teb tau tsim, thiab cov txiaj ntsim ntawm cov khoom siv ntawm tes uas peb tau sau cov qauv.
Yuav kom muab cov qauv tov rau cov seem hauv seem ntawm cov kab no, thiab, raws li, qhov feem pua rho tawm ntawm lwm kab, peb ua nyob rau hauv sab qis sab xis ntawm lub xov tooj uas muaj ib qho twb tau txais formula. Nias sab laug khawm ntawm nas thiab cab nws mus rau qhov kawg ntawm lub rooj. Yog li, peb yuav pom nyob hauv txhua tus xovtooj ntawm tes uas sawv cev rau tus nqi qub rho tawm qhov feem pua khwv.
Yog li, peb tau pom ob lub ntsiab tseem ceeb ntawm kev rho tawm feem pua ntawm tus nab npawb hauv Microsoft Excel: ua ib qho kev qhia yooj yim, thiab ua haujlwm hauv lub rooj. Raws li koj tau pom, cov txheej txheem kev rho tawm tsis txaus siab, thiab siv hauv cov ntawv yuav pab kom yooj yim rau kev ua haujlwm hauv lawv.
