Rage kashi daga adadin yayin lissafin lissafi ba haka bane. Misali, a cibiyoyin cinikayya, an cire kashi na VAT daga jimlar don saita farashin kaya ba tare da VAT ba. Mahukunta daban-daban na yin haka. Bari mu kuma za mu gano yadda za a rage kashi daga lamba a Microsoft Excel.
Rage kashi dari cikin Excel
Da farko dai, bari mu ga yadda aka rage kashi daga yawan baki daya. Don cire kashi daga lamba, dole ne a tantance nan da nan nawa, cikin sharuɗan adadi, zai zama wani kashi na adadin da aka bayar. Don yin wannan, ninka lambar asali ta kashi. Sannan, an rage sakamakon daga asalin lambar.
A cikin dabara mai inganci, zai yi kama da wannan: "= (lamba) - (lamba) * (kashi_value)%."
Nemi karin kashi bisa wani takamaiman misali. Da ace muna buƙatar rage 12% daga 48. Mun danna kowane sel a cikin takardar, ko sanya shigarwa a cikin masarar dabara: "= 48-48 * 12%".
Don aiwatar da ƙididdigar kuma ganin sakamakon, danna maɓallin ENTER akan maballin.
Rage kashi daga tebur
Yanzu bari mu gano yadda za a rage kashi daga bayanan da aka riga aka jera a cikin tebur.
Idan muna son rage wani sashi daga duk sel na takamaiman shafi, to, da farko, zamu iya kaiwa zuwa saman kanan tebur. Mun sanya alamar "=" a ciki. Na gaba, danna kan tantanin, yawan wanda kake son cirewa. Bayan haka, sanya alamar “-”, sannan kuma a sake danna wannan sel din da aka latsa kafin. Mun sanya alamar "*", kuma daga allon keyboard mun buga a cikin ƙimar kashi wanda ya kamata a rage. A karshen, sanya alamar "%".
Mun danna maɓallin ENTER, wanda daga baya ana yin lissafin, kuma ana nuna sakamakon a cikin tantanin da muka rubuta folila.
Domin kwafa kwayar dabara zuwa ga sauran sel wannan takarda, kuma, daidai da haka, an rage ƙarancin daga wasu layuka, mun zama a cikin ƙananan kusurwar dama na tantanin halitta wanda yanzu akwai ƙididdigar tsarin aikin. Mun danna maɓallin hagu a kan linzamin kwamfuta, kuma ja shi zuwa ƙarshen tebur. Don haka, zamu gani a cikin kowane lambobin tantanin halitta waɗanda ke wakiltar adadin ainihin an rage adadin da aka kafa.
Don haka, mun bincika manyan shari'o'i biyu na rage kashi daga lamba a Microsoft Excel: azaman ƙira mai sauƙi, kuma azaman aiki a tebur. Kamar yadda kake gani, hanya don cire riba ba ta da rikitarwa, kuma amfani da shi a cikin tebur yana taimaka wajan sauƙaƙe aikin a cikinsu.
