Isikhokelo seNyathelo-ngeNyathelo-nkqubo yokuNgeza iFomula yomvuzo weNtsholongwane kwi-Excel

01 ka 02

Ukongeza ifomula ukubala iMvuzo

Umrhumo weNqanaba lomvuzo uza kususa umvuzo we- Employer 's deduction kubalwe kwisinyathelo esedlule kuMvuzo oPhezulu womqeshwa .

02 we 02

Bala iiTtorial Steps Net Salary

Ukuze uncede kule miqathango, bhekisa kumfanekiso ongentla.

1. Ukuba kuyimfuneko, vula iphepha lokusebenzela elondolozwe kwisinyathelo sangaphambili sesifundo.
2. Cofa kwiseli F8 - indawo apho sifuna impendulo yefomula ivele khona.
3. Thayipha uphawu olulinganayo ( = ) ukuvumela i-Excel yazi ukuba siyakha ifom.
4. Cofa kwiseli D8 ukungena kule fom yesalathiso kwifom.
5. Thayipha uphawu lokunciphisa ( - ), ekubeni sithatha ixabiso elincinane.
6. Cofa kwiseli E8 ukungena kuloo fom yesalathiso kwifom.
7. Cinezela ENTER iqhosha kwikhibhodi ukugqiba ifom.
8. Impendulo ye- 47345.83 ifanele ivele kwiseli D8.
9. Xa ucofa kwiseli D8 ifomula = D8-E8 kufuneka ibonakale kwibha yefomula ngaphezu kwephepha lokusebenzela .
10. Londoloza iphepha lakho lomsebenzi.