Rage sha'awa daga lamba a lokacin lissafin lissafi ba irin wannan faruwar ba ne. Alal misali, a cikin cibiyoyin cinikayya ya karbi yawan VAT daga jimlar kuɗi don saita farashin kayayyaki ba tare da VAT ba. Ana gudanar da wannan ta hanyar hukumomi daban-daban. Bari mu da muka gano yadda za a cire kashi daga lambar a cikin Microsoft Excel.
Rawanin kashi cikin tarin
Da farko, bari mu ga yadda aka cire kashi-kashi daga cikin lambar a matsayin duka. Don cirewa daga kashi daga lambar, akwai buƙatar ka yanke shawarar ƙayyadadden ƙayyadaddun ka'idodin wannan lambar. Don yin wannan, ninka lambar asali ta darajar yawan. Bayan haka, an cire sakamakon ne daga lambar asali.
A cikin tsari na Excel, zai yi kama da wannan: "= (lambar) - (lambar) * (darajar kashi%%).
Muna nuna alamar sha'awa akan wani misali. Ƙila muna bukatar mu cire 12% daga lambar 48. Danna kan kowane salula na takardar, ko shigar da shigarwa a cikin tsari: "= 48-48 * 12%."
Don yin lissafi kuma ganin sakamakon, danna maballin ENTER a kan keyboard.
Rage sha'awa daga tebur
Yanzu bari mu kwatanta yadda za a rage yawan adadin bayanai da aka riga aka jera a cikin tebur.
Idan muna so mu cire wasu ƙwayoyin duka a cikin wani shafi, sa'an nan kuma, da farko, zamu kasance saman tarin kwayar halitta a cikin tebur. Mun sanya alamar "=". Kusa, danna kan tantanin halitta, wanda yawancin dole ne a cire shi. Bayan haka, sa alamar "-", sannan kuma danna kan tantanin halitta, wanda aka latsa kafin. Mun sanya alamar "*", kuma daga keyboard mun rubuta adadin kashi, wanda ya kamata a cire shi. A karshen sa alamar "%".
Mun danna kan maɓallin ENTER, bayan haka, ana yin lissafin, kuma sakamakon shine fitarwa zuwa tantanin halitta wanda muka rubuta wannan tsari.
Domin yakamata a kofe dashi ga sauran sassan wannan shafi, kuma, daidai da haka, an cire kashi daga wasu layuka, mun kasance a cikin kusurwar dama na tantanin halitta inda akwai lissafin lissafi. Latsa maɓallin hagu a kan linzamin kwamfuta kuma ja shi zuwa ƙarshen tebur. Saboda haka, za mu ga a cikin kowane lambobin lambobin da ke wakiltar adadin asalin adadin ƙayyadaddun kashi.
Sabili da haka, munyi la'akari da manyan laifuka biyu na rage kashi daga kashi daga cikin Microsoft Excel: a matsayin lissafi mai sauƙi, kuma a matsayin aiki a tebur. Kamar yadda kake gani, hanyar da za a cire amfani da shi ba ma rikitarwa ba, kuma yin amfani da shi a cikin tebur yana taimakawa wajen rage sauƙin aikin a cikinsu.
