Peresenti yosintha formula mu Excel

Njira yosinthira peresenti imagwiritsidwa ntchito kwambiri mu Excel. Mwachitsanzo, kuwerengera mwezi uliwonse kapena kusintha kwathunthu.

Kusintha kwa mwezi uliwonse

1. Sankhani selo C3 ndipo lowetsani ndondomeko yomwe ili pansipa.
2. Sankhani selo C3 ndikugwiritsa ntchito mtundu wa maperesenti kwa izo.
3. Kuti musabwereze gawo la 1 ndi lachiwiri nthawi khumi, sankhani selo C3, dinani pakona yake yakumanja yakumanja ndikuikokera ku selo C13.
4. Onani ngati zonse zayenda bwino.

Kusintha kwanthawi zonse

1. Mofananamo, tikhoza kuwerengera kusintha kwathunthu. Nthawi ino tikukonza zolozera ku selo V2. Onetsani selo D3 ndipo lowetsani ndondomeko yomwe ili pansipa.
2. Sankhani selo D3 ndikugwiritsa ntchito mtundu wa maperesenti kwa izo.
3. Onetsani selo D3, dinani pakona yake yakumanja yakumanja ndikuikokera ku selo D13.
4. Onani ngati zonse zayenda bwino.

Kufotokozera: Tikakokera (kukopera) fomula pansi, zofotokozera mtheradi ($ B $ 2) zimakhalabe zosasinthika, koma zofotokozera (B3) zikusintha - B4, B5, B6, ndi zina zotero. Chitsanzochi chingakhale chovuta kwambiri kwa inu panthawiyi, koma ikuwonetsa zina mwazinthu zothandiza komanso zamphamvu zomwe Excel ili nazo.