Ho tlosoa ha liperesente ho tloha lipalo nakong ea lipalo tsa lipalo hase ntho e etsahalang seoelo. Mohlala, mekhatlong ea khoebo, liperesente tsa VAT li theoleloa ho kakaretso ho beha theko ea thepa ntle le VAT. Balaoli ba fapaneng ba taolo le bona ba etsa joalo. A re ke re boneng hore na re ka ntša karolo e kae lekholong ho Microsoft Excel.
Ho nts'oa liperesente ho Excel
Pele ho tsohle, a re boneng hore na liphesente li ntšoa joang ho tsoa palo kaofela. Ho tlosa liperesente ho tsoa ho nomoro, o lokela ho bonts'a hang-hang hore na ke bokae, ka mantsoe a mangata, e tla ba karolo e itseng ea palo e fanoeng. Ho etsa sena, eketsa nomoro ea pele ka peresente. Ebe, sephetho se tlosoa ho nomoro ea pele.
Ka lifomate tsa Excel, e tla shebahala tjena: "= (palo) - (nomoro) * (liphesente_value)%."
Bontša ho tlosoa ha liperesente ho mohlala o itseng. A re re re hloka ho tlosa 12% ho 48. Re tobetsa seleng efe kapa efe ka har'a pampiri, kapa re kenelle ka har'a foromo ea foromo: "= 48-48 * 12%".
Ho etsa lipalo le ho bona sephetho, tlanya ho ENTER konopo ho keyboard.
Ho nts'oa liperesente tse ngata tafoleng
Joale, a re boneng hore na re ka tlosa peresente joang ho tsoa ho data e seng e thathamisitsoe tafoleng.
Haeba re batla ho tlosa liperesente tse itseng ho tsoa liseleng tsohle tsa kholomo e itseng, ebe, pele ho tsohle, re fihla seleng e holimo haholo e se nang letho ea tafole. Re beha letšoao "=" ho eona. Ka mor'a moo, tlanya ka seleng, karolo eo u batlang ho e tlosa. Kamora moo, beha "-" pontso ebe u tobetsa sele e le 'ngoe e neng e tobetsoe pele. Re beha letšoao la "*", 'me ho tloha khibotong re thaepa ka boleng ba liperesente tse lokelang ho tlosoa. Qetellong, beha letšoao "%".
Re tobetsa konopo ea ENTER, ka mor'a moo lipalo li etsoa, 'me sephetho se hlahisoa seleng eo re ngotseng formula ka eona.
E le hore foromo e ka kopitsoa ho lisele tse ling tsa kholomo ena, 'me, ka lebaka leo, liperesente li ne li tlositsoe mela e meng, re ba sekhutlong se ka tlase sa lejoe la sele eo ho seng ho entsoe formula e baliloeng. Re tobetsa konopo e ka letsohong le letšehali ho panya, ebe re e hulanya ho ea qetellong ea tafole. Kahoo, re tla bona ka palo ea sele ka 'ngoe e emelang palo ea mantlha ho latela liperesente tse thehiloeng.
Kahoo, re ile ra hlahloba linyeoe tse peli tsa mantlha tsa ho tlosa liperesente ho tsoa palo ho Microsoft Excel: e le lipalo tse bonolo, le ts'ebetso tafoleng. Joalokaha u bona, ts'ebetso ea ho tlosa thahasello ha e thata haholo, mme ts'ebeliso ea eona matlapeng e thusa ho nolofatsa mosebetsi ho bona.
