Tataiso ea Mohato oa Mehato ea Mehato ea ho Fetisetsa Formula ea Moputso ea Net ka Excel

01 ea 02

Ho eketsa Mohoeletsi oa ho Bala Mesebetsi ea Net

Ho eketsa liforomo ka Excel. © Ted French

Mekhoa ea Monehelo oa Net e tla tlosa palo ea ho fokotsa basebetsi e baloang mohato o fetileng ho Gross Salary ea mosebeletsi .

02 ea 02

Fumana Tutorial Steps

Bakeng sa thuso ho mehato ena, sheba setšoantšo se ka holimo.

  1. Haeba ho hlokahala, bula leqephe la leqephe le bolokiloe mohato oa pele oa thupelo.
  2. Tobetsa ho cell F8 - sebaka seo re batlang hore karabo ea potso e hlahe.
  3. Ngola letšoao le lekanang ( = ) ho lumella Excel ho tseba hore re ntse re etsa foromo.
  4. Tobetsa seleng ea D8 ho kena selekaneng eo ea sele ka mokhoa ona.
  5. Ngola letšoao le letšo ( - ), kaha re tlosa chelete e le 'ngoe.
  6. Tobetsa ho cell E8 ho kenya sele eo sebopeho.
  7. Tobetsa konter ENTER ho lebokose ho tlatsa foromo.
  8. Karabo 47345.83 e lokela ho hlaha ka seleng ea D8.
  9. Ha o tobetsa seleng D8 foromo = D8 - E8 e lokela ho bonahala kahare ea foromo ka holim'a leqephe .
  10. Boloka mokhoa oa hau oa mosebetsi.