Nhungamiro Yokufamba-Nenzira yekuwedzera kuNet Salary Formula muExpcel

01 ye 02

Kuwedzera Purogiramu Kuverenga Net Salary

Mutengo weNet Salary uchatora chikamu chekudzikunura kwechishanda chakaverengwa muchitsauko chekare kubva kune Gross Salary yevashandi .

02 of 02

Shandisa Net Salary Tutorial Steps

Kuti ubatsirwe pamatanho aya, tarisa pamufananidzo uri pamusoro.

1. Kana zvichidikanwa, shandisa pepa rekuchengetedza rakachengetwa mudanho rekare rekudzidzisa.
2. Dzvanya pane cell F8 - nzvimbo yatinoda kuti mhinduro yefomula ionekwe.
3. Tora imwechete yeiyo ( = ) kuti rega Excel zive kuti tiri kusika fomu.
4. Dzvanyira pane sero D8 kuti uise iyo seferensi iri mumutsetse.
5. Tora minus sign ( - ), sezvo tiri kubvisa zviyero zviviri.
6. Dzvanyira pane cell E8 kuti uise iyo sero rekuita mumutsetse.
7. Dhinda iyo ENTER key pabhokisi kuti upedze fomu.
8. Mhinduro 47345.83 inofanira kuonekwa muchitokisi D8.
9. Paunenge uchinyora pane cell D8 iyo formula = D8 - E8 inofanira kuonekwa mubhairi yepamusoro pane pepa pepaji .
10. Chengetedza shandi yako yebasa.