Lokacin gudanar da lissafin iri-iri, wani lokaci kuna buƙatar ninka lambar ta kashi. Misali, ana amfani da wannan lissafin wajen ƙididdige adadin izinin ciniki cikin sharuɗan kuɗaɗen, tare da sananne izinin kashi. Abin takaici, wannan ba aiki mai sauƙi ba ne ga kowane mai amfani. Bari mu ayyana yadda za a ninka lamba zuwa kashi a Microsoft Excel.
Maimaita lamba da kashi dari
A zahiri, kashi ɗari ɗari na lamba ne. Wato, lokacin da suka faɗi, alal misali, sau biyar 13% - daidai yake da sau 5 0.13. A cikin Excel, ana iya rubuta wannan magana azaman "= 5 * 13%." Don ƙididdigewa, wannan magana tana buƙatar rubuta shi a cikin layin ƙira, ko a kowace sel akan takardar.
Don ganin sakamako a cikin sel da aka zaɓa, danna danna maɓallin ENTER akan maɓallin kwamfutar.
A kusan hanya guda, zaka iya shirya ninka ta hanyar saita yawan bayanan data. Don yin wannan, mun zama a cikin tantanin da za a nuna sakamakon lissafi. Zai yi kyau wannan sel ya kasance akan layi ɗaya da adadin da za'a ƙididdige shi. Amma wannan ba wani abu ake bukata ba ne. Mun sanya alamar daidai ("=") a cikin wannan tantanin, kuma danna kan tantanin da ke dauke da lambar asali. Bayan haka, mun sanya alamar ninka ("*"), kuma mun buga kan maɓallin keyboard adadin da muke so mu ninka lamba. A ƙarshen rikodin kar ku manta da sanya alamar kashi ("%").
Domin nuna sakamakon a takardar, danna maɓallin ENTER.
Idan ya cancanta, ana iya amfani da wannan matakin zuwa wasu ƙwayoyin ta hanyar kwafin tsari kawai. Misali, idan data kasance a cikin tebur, to kawai a tsaya a ƙasan dama na sel a inda aka jefa dabara, kuma tare da maɓallin linzamin kwamfuta na hagu, danna shi zuwa ƙarshen teburin. Ta haka ne, za a kwafa fom din zuwa dukkanin sel, kuma ba lallai ne ku fitar da shi da hannu ba don yin lissafin adadin lambobi ta wani adadin.
Kamar yadda kake gani, tare da ninka adadin da kashi a Microsoft Excel, bai kamata a sami wata matsala ta musamman ba kawai ga masu amfani da kwarewa, har ma da masu farawa. Wannan jagorar zata taimaka muku wajen sanin wannan tsari ba tare da matsaloli ba.
