Darasi kan cire kaso daga lamba a Excel

Sau da yawa, a cikin lissafin lissafin lissafi daban-daban, ana amfani da raguwar kashi daga takamaiman lamba. Yawancin kamfanoni, alal misali, suna amfani da ragi don saita farashin samfur, don ƙididdige ribar da aka samu, da sauransu.

A cikin wannan darasi, za mu yi ƙoƙari mu gaya muku cikin sauƙi kamar yadda za ku iya cire kashi daidai daga lamba a cikin Excel. Ya kamata a lura cewa kowane aiki yana da hanya. Bari mu ci gaba zuwa abubuwan da ke ciki.

Cire kaso daga lamba

Don cire kashi daga takamaiman lamba, da farko kuna buƙatar ƙididdige cikakkiyar ƙimar adadin daga lambar da aka bayar, sannan ku cire ƙimar da aka samu daga ainihin.

A cikin Excel, wannan aikin lissafi yayi kama da haka:

= Lambobi (cell) - Lambobi (cell) * Kashi (%).

Misali, cire kashi 23% daga lamba 56 an rubuta kamar haka: 56-56 * 23%.

Shigar da ƙimar ku a cikin kowane tantanin halitta kyauta na tebur, kawai danna maɓallin "Shigar", kuma sakamakon da aka gama zai bayyana a cikin tantanin halitta da aka zaɓa.

Rage kashi a cikin tebur da aka kammala

Amma abin da za a yi idan an riga an shigar da bayanan a cikin tebur, kuma lissafin hannu zai ɗauki lokaci mai yawa da ƙoƙari?

1. Don cire kaso daga dukkan sel na ginshiƙan, ya isa ka zaɓi tantanin halitta kyauta na ƙarshe a cikin layin da kake son ƙididdigewa, rubuta alamar “=”, sannan danna kan tantanin halitta wanda kake son cire kashi. sannan rubuta alamar “-” da ƙimar kashi da ake buƙata, kar a manta da rubuta alamar “%” kanta.

   

   Na gaba, danna maɓallin "Shigar", kuma a zahiri a cikin ɗan lokaci sakamakon zai bayyana a cikin tantanin halitta inda aka shigar da dabarar.

   

   Don haka kawai mun cire kashi daga tantanin halitta ɗaya. Yanzu bari mu sarrafa tsarin kuma nan take za mu cire adadin da ake so daga duk ƙimar tantanin halitta a cikin ginshiƙin da aka zaɓa. Don yin wannan, danna hagu a ƙasan kusurwar dama na tantanin halitta inda aka yi lissafin a baya, kuma riƙe wannan kusurwar, kawai ja tantanin halitta tare da dabarar ƙasa zuwa ƙarshen ginshiƙi ko zuwa kewayon da ake so.

   

   Don haka, sakamakon cire wani kaso daga duk ƙimar da ke cikin ginshiƙi za a ƙididdige shi nan take kuma a sanya shi a wurinsa.

   

2. Ya faru da cewa tebur ya ƙunshi ba kawai cikakkun dabi'u ba, har ma da dangi, watau akwai rigar shafi tare da cike da kashi da ke cikin lissafin. A wannan yanayin, kamar zaɓin da aka yi la'akari da shi a baya, muna zaɓar tantanin halitta kyauta a ƙarshen layin kuma mu rubuta dabarar lissafi, maye gurbin ƙimar kashi tare da daidaitawar tantanin halitta wanda ke ɗauke da kashi.

   

   Na gaba, danna "Enter" kuma muna samun sakamakon da ake so a cikin tantanin halitta da muke bukata.

   

   Hakanan za'a iya jan dabarar lissafin zuwa ragowar layukan.

   

Rage kashi a kayyade % tebur

Bari mu ce muna da tantanin halitta guda ɗaya a cikin tebur wanda ya ƙunshi kashi wanda ake buƙatar amfani da shi don ƙididdige ginshiƙi gabaɗaya.

A wannan yanayin, tsarin lissafin zai yi kama da wannan (ta amfani da cell G2 a matsayin misali):

lura: Ana iya rubuta alamun "$" da hannu, ko kuma ta hanyar shawagi siginan kwamfuta akan tantanin halitta tare da kaso a cikin dabara, danna maɓallin "F4". Ta wannan hanyar, zaku gyara tantanin halitta tare da kaso, kuma ba zai canza ba lokacin da kuka shimfiɗa dabarar zuwa wasu layin.

Sa'an nan kuma danna "Enter" kuma za a lissafta sakamakon.

Yanzu zaku iya shimfiɗa tantanin halitta tare da dabara ta hanyar kama da misalan da suka gabata zuwa sauran layin.

Kammalawa

A cikin wannan labarin, an yi la'akari da mafi mashahuri kuma mafi dacewa hanyoyin, yadda za a cire wani kashi biyu daga wani ƙima kuma daga shafi tare da cikakkun dabi'u. Kamar yadda kake gani, yin irin waɗannan ƙididdiga abu ne mai sauƙi, mutum yana iya sauƙin sarrafa su ba tare da wani ƙwarewa na musamman ba a cikin aiki akan PC da Excel musamman. Yin amfani da waɗannan hanyoyin zai sauƙaƙe aikin tare da lambobi da adana lokacinku.