Ƙara lamba ta kashi a cikin Microsoft Excel

Yayin da ake yin lissafi daban-daban, yana da lokaci mahimmanci don ninka lambar ta kashi. Alal misali, ana amfani da wannan lissafi wajen ƙayyade adadin alamar ciniki a cikin ka'idodin kuɗi, tare da sanannun kashi na Premium. Abin takaici, wannan ba mai sauki ba ne ga kowane mai amfani. Bari mu bayyana yadda za a ninka lambar ta kashi a cikin Microsoft Excel.

Haɓaka yawan ta kashi

A gaskiya, kashi shine kashi ɗari na lambar. Wato, idan sun ce, alal misali, biyar da suka karu da kashi 13% daidai yake da ninka 5 da lambar 0.13. A cikin Excel, ana iya rubuta wannan magana a matsayin "= 5 * 13%". Don ƙididdige wannan magana kana buƙatar rubutawa a cikin layin layi, ko kuma a kowane tantanin halitta a kan takardar.

Don ganin sakamakon a cikin cell da aka zaɓa, kawai danna maballin ENTER akan keyboard.

Kusan kamar wannan hanya, zaka iya shirya yawancin ta hanyar yawan adadin bayanai na tabula. Don yin wannan, zamu shiga cikin tantanin halitta inda za a nuna sakamakon lissafin. Yana da kyau don wannan tantanin halitta ya kasance a jere guda ɗaya kamar lambar da za a lissafta. Amma wannan ba abinda ake bukata ba. Mun sanya alamar daidai ("=") a wannan tantanin halitta, kuma danna kan tantanin salula da ke ƙunshe da lambar asali. Sa'an nan kuma, mun sanya alamar ƙaddamarwa ("*"), da kuma rubuta a kan maɓallin keyboard girman yawan da muke so mu ninka lambar. A ƙarshen rikodin, kada ka manta ka sanya alamar kashi ("%").

Domin nuna sakamakon a kan takardar, danna maballin ENTER.

Lokacin da ake buƙata, wannan aikin za a iya amfani da shi zuwa wasu kwayoyin, kawai ta hanyar kwafin wannan tsari. Alal misali, idan an samo bayanai a cikin tebur, to, ya isa kawai don tsayawa a kusurwar dama na tantanin halitta inda aka kayyade tsari, kuma tare da maɓallin linzamin hagu na riƙe, riƙe shi zuwa ƙarshen tebur. Saboda haka, za a kwashe ma'anar ta zuwa dukkanin kwayoyin, kuma ba za ka iya fitar da shi ba da hannu don lissafta yawan yawan lambobi ta takamaiman ƙimar.

Kamar yadda ka gani, tare da yawancin yawan lambar ta kashi a cikin Microsoft Excel, babu matsalolin musamman ba kawai ga masu amfani da gogaggen ba, amma har ma don shiga. Wannan jagorar zai ba ka izinin sauƙin sarrafa wannan tsari.