Umhlahlandlela Wokuzinyathelo Wokungeza I-Formula Ye-Salary Net ku-Excel

01 ngo-02

Ukwengeza ifomula ukubala umholo we-Net

Umshini we-Net Salary uzokhipha isamba sokukhishwa kwesisebenzi esibalwe kwisinyathelo sangaphambilini esivela ku- Gross Salary yomsebenzi .

02 ka 02

Bala Izitebhisi Zemivuzo Ye-Net

Ukuze uthole usizo kulezi zinyathelo, bhekisela esithombeni ngenhla.

1. Uma kunesidingo, vula ishidi lokusebenzela elondolozwe kwisinyathelo sangaphambili sesifundo.
2. Chofoza kuseli F8 - indawo lapho sifuna impendulo yefomula ukuthi ivele khona.
3. Thayipha uphawu olulinganayo ( = ) ukuze uvumele i-Excel ukuthi sidala ifomula.
4. Chofoza ku-cell D8 ukuze ufake leyo reference yereli kwifomula.
5. Thayipha uphawu lokushicilela ( - ), njengoba sisusa imali emibili.
6. Chofoza ku-cell E8 ukuze ufake leyo reference yeselula kwifomula.
7. Cindezela inkinobho ENTER ekhibhodi ukuqedela ifomula.
8. Impendulo 47345.83 kufanele ivele kuseli D8.
9. Uma uchofoza ku-cell D8 ifomula = D8 - E8 kufanele ibonakale kubha yefomula ngaphezulu kwephepha lokusebenzela .
10. Londoloza ishidi lakho lokusebenzela.