Bukhu lotsogolera pang'onopang'ono kuti muwonjezeko Mphoto ya Salamu mu Excel

01 a 02

Kuonjezera Mpangidwe Wowonetsera Ndalama Zowonjezera

Ndalama ya Net Salary idzachotsa ndalama za Kuchokera kwa wogwira ntchito zomwe zawerengedwera pamtunda wapitawo kuchokera ku Gross Salary ya ogwira ntchito .

02 a 02

Gwiritsani ntchito Maphunziro a Net Salary Steps

Kuti muthandizidwe pazitsulozi, onetsani chithunzi pamwambapa.

1. Ngati ndi kotheka, tsegula pepala lamasewerolo losungidwa mu sitepe yapitayi.
2. Dinani pa selo F8 - malo omwe tikufuna kuti yankho la funsolo liwonekere.
3. Lembani chizindikiro chofanana ( = ) kuti Excel adziwe kuti tikupanga chilinganizo.
4. Dinani pa selo D8 kuti mulowetse selolo mu njirayi.
5. Lembani chizindikiro chochepa ( - ), popeza tikuchotsa ndalama ziwiri.
6. Dinani pa selo E8 kuti mulowetse selolo mu njirayi.
7. Onetsetsani ENTER mmanja pa kibokosiko kuti mutsirize fomuyi.
8. Yankho la 47345.83 liyenera kuoneka mu selo D8.
9. Mukasindikiza pa selo D8 mndandanda = D8 - E8 iyenera kuwonetsedwa mu barolo lazenera pamwamba pa tsamba .
10. Sungani tsamba lanu la ntchito.