A lokacin da gudanar da lissafin daban-daban, wani lokaci wani lokacin ake zama dole don ninka yawan adadin adadin. Misali, ana amfani da wannan lissafin wajen tantance adadin ƙarin biyan ciniki a cikin sharuddan kuɗi, tare da sanannun kashi na izni. Abin takaici, ba ga kowane mai amfani ba ne mai sauƙi. Bari mu tantance yadda ake ninka yawan adadin a cikin aikace-aikacen Microsoft Excel.
Yawan adadin adadin adadin
A zahiri, kashi shine rabin ɗari na lamba. Wato, lokacin da suka ce, alal misali, biyar ninka da 13% - Haka yake kamar 5 sun yawaita ta lamba 0.13. A cikin shirin Excel, wannan magana za a rubuta a matsayin "= 5 * 13%". Lissafi, dole ne a rubuta wannan magana zuwa zaren formula, ko a cikin wani sel a kan takardar.
Don ganin sakamakon da aka zaɓa, kawai danna maɓallin Shigar da maɓallin kwamfuta.
A cikin kusan hanyar, zaku iya yin ninka zuwa kashi kashi na bayanan bayanai. A saboda wannan, mun zama sel inda za a nuna sakamakon lissafin. Da ya dace zai zama cewa wannan tantanin halitta yana cikin layi ɗaya kamar lamba don lissafin. Amma wannan ba abin da ake bukata bane. Mun sanya a cikin wannan sel alama ce ta daidaici ("="), kuma danna kan tantanin, wanda ya ƙunshi lambar tushe. Bayan haka, sanya alamar da yawa ("*"), kuma ci kimanin ƙimar akan keyboard ɗin da kake son ninka lamba. A ƙarshen rikodin, kar a manta a sanya alamar kashi ("%").
Domin fitarwa sakamakon shafin danna kan maɓallin Shigar.
Idan ya cancanta, ana iya amfani da wannan aikin zuwa wasu sel ta hanyar kwafin tsari. Misali, idan bayanan suna cikin tebur, ya isa kawai don tashi zuwa ƙananan kusurwar dama na sel, kuma lokacin da aka yi wa linzamin kwamfuta, da kuma lokacin da aka kashe shi zuwa ƙarshen teburin. Don haka, za a kwafa dabara ga duk sel, kuma ba lallai ba ne don fitar da shi da hannu don yin lissafin ninka lambobi zuwa takamaiman adadin.
Kamar yadda kake gani, tare da ninka yawan adadin a cikin shirin Microsoft Excel, babu matsala na musamman ba kawai don ƙwararrun masu amfani ba, har ma da Newbies. Wannan jagorar zai ba ku damar koyon wannan aikin ba tare da wata matsala ba.