Yadda ake ƙara sha'awa ga lambar da ke fice

Anonim

Ƙara sha'awa ga chille a Microsoft Excel

A yayin lissafi, wani lokacin yana da mahimmanci don ƙara sha'awa ga takamaiman lamba. Misali, don koyon alamun riba na yanzu, wanda ya karu da wani kashi ɗaya idan aka kwatanta da watan da ya gabata, ya zama dole don ƙara wannan kashi zuwa girman ribar ribar da ta gabata. Akwai wasu misalai da yawa lokacin da kuke buƙatar aiwatar da irin wannan matakin. Bari mu gano yadda ake ƙara kashi zuwa lambar a Microsoft Excel.

Computing ayyuka a cikin tantanin halitta

Don haka, idan kawai kuna buƙatar sanin abin da adadi zai zama daidai da, bayan ƙari na wani kashi, yana bin kowane sel na takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin ƙirar takarda, ko a cikin zaren bisa ga samfurin mai zuwa: "= (lamba) + (lamba) * (darajar_)%."

A ce muna bukatar lissafta abin da lambar da ta yi idan ka kara zuwa kashi 14 cikin ɗari. Muna rubuta makircin masu zuwa cikin kowane tantanin halitta, ko a cikin kirjin formula: "= 140 + 140 * 20%".

Dabara don kirga kashi a cikin shirin Microsoft Excel Shirin

Na gaba, danna maɓallin Shigar a kan keyboard, kuma muna kallon sakamakon.

Lissafin kashi yana haifar da Microsoft Excel

Aikace-aikacen formla don aiki a cikin tebur

Yanzu, bari mu tantance yadda ake ƙara wani kashi zuwa bayanan da suka riga sun kasance a cikin tebur.

Da farko, zabi salula inda za'a nuna sakamakon. Mun sanya alamar "=". Bayan haka, danna kan kwayar da ke dauke da bayanan da ya kamata a ƙara adadin. Sanya alamar "+". Kuma, ta danna kan tantanin da ke ɗauke da lamba, sanya alamar "*". Bayan haka, muna buga ƙimar kashi akan maɓallin da ya kamata lamba ta karu. Kada ka manta bayan shigar da wannan darajar don sanya alamar "%".

Tsarin tsari don kirga kashi na tebur a cikin shirin Microsoft Excel Shirin

Danna maɓallin Shigar a kan mabuɗin mabuɗin, bayan da sakamakon lissafin za a nuna.

Lissafin kashi yana haifar da shirin Microsoft Excel don tebur

Idan kana son rarraba wannan tsari zuwa duk ka'idodin shafi a teburin, to kawai ka zama gefen dama na tantanin halitta inda aka samo asali. Dole ne siginar dole ta zama gicciye. Mun danna maballin linzamin kwamfuta na hagu, kuma tare da "Matsa" misali zuwa ƙarshen ƙarshen tebur.

Shimfiɗa dabara a cikin Microsoft Excel

Kamar yadda kake gani, sakamakon da yawaita lambobi zuwa wani adadin da aka samo don sauran sel a shafi.

Sakamakon shimfidawa da tsari a cikin shirin Microsoft Excel Shirin

Mun gano cewa ƙara yawan adadin a cikin shirin Microsoft Excel ba shi da wahala. Koyaya, yawancin masu amfani ba su san yadda ake yin shi ba, kuma suna yin kuskure. Misali, kuskuren gama gari shine rubutun da aka tsara bisa ga Algorithm "= (Lambar) (lamba_) (lamba_) = (lamba) (lamba) (lamba_) *. Wannan littafin ya kamata taimaka hana irin wadannan kurakurai.

Kara karantawa