Tallaabo-tallaabo-tallaabo-tallaabo ah oo loogu talagalay Qodobka Mushaharka Net ee Excel

01 ee 02

Ku darista Naqshad Si Loo Xisaabiyo Mushaharka Net

Ku darista Hababka Excel. © Ted Faransiis

Naqshadda Net Mushaharka ayaa ka gooysaaya qadarka lacagta shaqaale ee lagu xisaabiyay tallaabada hore ee ka soo gashay Mushaharka Guud ee Shaqaalaha .

02 of 02

Xisaabinta Talaabooyinka Tababbarka Mushaharka ee Net

Si aad uga caawiso talaabooyinkan, tixraac sawirka kor ku xusan.

  1. Haddii ay lagama maarmaan noqoto, fur furka waraaqaha shaqada oo lagu badbaadiyey tallaabada hore ee casharka.
  2. Riix batoonka F8 - meesha aan rabno jawaabta caanaha naqshada ee muuqda.
  3. Ku qor calaamad isku mid ah ( = ) si aad u oggolaato Excel in aan ogaanno naqshadeynta.
  4. Riix batoonka D8 si aad u gashid tixraaca unugyada ee foomka.
  5. Calaamadee calaamada laga jaray ( - ), maadaama aan ka jareyno laba qiyaasood.
  6. Guji unugga E8 si aad u gashid tixraaca unugyada ee foomka.
  7. Ku riix furaha ENTER ee kumbuyuutarka si aad u buuxiso caanaha.
  8. Jawaabta 47345.83 waa inay ka muuqataa unugga D8.
  9. Marka aad gujiso unug D8 waa formula = D8 - E8 waa in muuqaal laga eegaa foomka kore ee warqadda shaqada .
  10. Badbaadi waraaqdaada shaqada.