Zamkatimu
Nthawi zambiri, powerengera masamu osiyanasiyana, kuchotsa maperesenti pa nambala inayake kumagwiritsidwa ntchito. Makampani ambiri, mwachitsanzo, amagwiritsa ntchito kuchotsa poika mtengo wa chinthu, kuwerengera phindu lomwe apeza, ndi zina zotero.
Mu phunziro ili, tiyesetsa kukuuzani mosavuta momwe tingachotsere kuchuluka kwa chiwerengero mu Excel. Ndikoyenera kudziwa kuti pa ntchito iliyonse pali njira. Tiyeni tipitirire ku zomwe zili.
Timasangalala
Chotsani maperesenti pa nambala
Kuti muchotse peresenti pa nambala inayake, choyamba muyenera kuwerengera mtengo wokwanira wa chiwerengerocho kuchokera pa nambala yomwe mwapatsidwa, ndiyeno muchotse mtengowo kuchokera pa choyambirira.
Mu Excel, masamu amawoneka motere:
= Digit (selo) - Digit (selo) * Peresenti (%).
Mwachitsanzo, kuchotsa 23% pa nambala 56 kwalembedwa motere: 56-56 * 23%.
Kulowetsa zikhalidwe zanu mu cell iliyonse yaulere patebulo, ingodinani pa kiyi ya "Enter", ndipo zotsatira zomaliza zidzawonekera mu cell yomwe mwasankha.
Chotsani magawo mu tebulo lomalizidwa
Koma chochita ngati deta yalowa kale patebulo, ndipo kuwerengera pamanja kudzatenga nthawi yambiri ndi khama?
- Kuti muchotse chiwerengerocho pamaselo onse a mzati, ndikwanira kusankha selo lomaliza laulere pamzere womwe mukufuna kuwerengera, lembani chizindikiro "=", kenako dinani pa selo lomwe mukufuna kuchotsa peresenti, kenako lembani chizindikiro "-" ndi mtengo wofunikira, osaiwala kulemba chizindikiro "%" chokha.
Kenako, dinani batani la "Enter", ndipo pakanthawi kochepa zotsatira zake zidzawonekera mu cell yomwe fomula idalowetsedwa.
Chifukwa chake tangochotsa gawo limodzi kuchokera ku selo imodzi. Tsopano tiyeni tisinthe ndondomekoyi ndikuchotsa nthawi yomweyo kuchuluka komwe mukufuna kumagulu onse a cell mugawo losankhidwa. Kuti muchite izi, dinani kumanzere kumunsi kumanja kwa cell komwe kuwerengera kudapangidwa kale, ndikugwirizira ngodya iyi, ingokokerani selo ndi chilinganizo mpaka kumapeto kwa gawolo kapena kumtundu womwe mukufuna.
Chifukwa chake, chotsatira chochotsa peresenti inayake pamikhalidwe yonse yomwe ili mgawoli idzawerengedwa nthawi yomweyo ndikuyika m'malo mwake.
- Zimachitika kuti tebulo lili ndi zikhalidwe zenizeni, komanso zachibale, mwachitsanzo, pali kale ndime yokhala ndi maperesenti odzaza omwe akukhudzidwa pakuwerengera. Pachifukwa ichi, mofanana ndi njira yomwe inaganiziridwa kale, timasankha selo laulere kumapeto kwa mzere ndikulemba ndondomeko yowerengera, m'malo mwa chiwerengero cha chiwerengero ndi makonzedwe a selo omwe ali ndi chiwerengerocho.
Kenako, dinani "Lowani" ndipo timapeza zotsatira zomwe tikufuna mu cell yomwe tikufuna.
Njira yowerengera imathanso kukokera ku mizere yotsalayo.
Chotsani maperesenti mu tebulo lokhazikika la %.
Tiyerekeze kuti tili ndi selo limodzi patebulo lomwe lili ndi peresenti yomwe iyenera kugwiritsidwa ntchito kuwerengera gawo lonse.
Pankhaniyi, njira yowerengera idzawoneka motere (pogwiritsa ntchito selo G2 monga chitsanzo):
Zindikirani: Zizindikiro za "$" zitha kulembedwa pamanja, kapena kusuntha cholozera pa selo ndi maperesenti mu fomula, dinani batani la "F4". Mwanjira iyi, mudzakonza selo ndi maperesenti, ndipo sichidzasintha mukatambasula chilinganizo ku mizere ina.
Kenako dinani "Enter" ndipo zotsatira zake zidzawerengedwa.
Tsopano mutha kutambasula selo ndi ndondomekoyi mofanana ndi zitsanzo zam'mbuyo ku mizere yonse.
Kutsiliza
M'nkhaniyi, njira zodziwika bwino komanso zosavuta zidalingaliridwa, momwe mungachotsere gawo lina lililonse pamtengo wina komanso kuchokera pagawo lokhala ndi zikhalidwe zodzaza. Monga mukuwonera, kuwerengera kotere ndikosavuta, munthu amatha kuzigwira mosavuta popanda luso lapadera logwira ntchito pa PC komanso ku Excel makamaka. Kugwiritsa ntchito njirazi kumathandizira kwambiri ntchitoyo ndi manambala ndikusunga nthawi yanu.