Ka rite ki i roto i "Eksele" tātai ōrau: ariā matua

I teie mahana, e rave rahi kaiwhakamahi rorohiko paanga i roto i te pātai o te pehea, ki te "Eksele" tātai ōrau. Ko te pono tenei no te mea maha i roto i ripakaute raraunga i roto i tau. A, no te haere mai te reira ki a Excel, maha pa ki runga ki te ōrau me te ōrau rerekētanga.

moni 101

Ahakoa e taea e Excel maha mea mahi, e kore e taea ki te whakaako a koutou pāngarau te hōtaka. Na reira, etahi matauranga taketake e hiahia ana koe ki te haere. Hei whakaatu i te tokomaha i roto i te puka o te moni ki a Excel, me whakamahi rawa hangaia koe mo tenei hōputu. Hei whakamahi i te reira, tīpako i te pūtau ki kia i raro ki te hōputu, a ka pāwhiri "ōrau" i roto i te rōpū "maha" ripa "Home" (whakanohoia ki runga ki te rīpene). Te kōrero e pā ana ki te pehea, ki te "Eksele" tātai moni, mōhio tatou i mea ai te tere tenei e te whakamahi i pahekotanga pātuhi wera Ctrl + Shift +%.

I roto i te Excel, kei te rongoa tonu te uara turanga i roto i te puka-ira. Ko te kupu, ara, ki te whakamahi koe i te hōputu motuhake mō te whakaatu tetahi i roto i te ōrau (10%), ko reira he kanohi tohu o te uara turanga. I roto i te mau parau te tahi atu, mahi tonu Excel tātaitanga i roto i te uara ira (0,1). Ki rua-taki i te reira, tīpako i te pūtau, pēhi Ctrl + 1 me te titiro ki ngā tauira o te parae i te "kāwai General".

ariā taketake

Hōputu te ōrau e titiro i te iti uaua. Na reira, ki te mārama me pēhea ki te tātai ōrau i roto i Excel, kia whakaaro koe ki te whai ake.

Ko te hōputu o te uara ngā i roto i te tono o te uara ōrau i roto i te pūtau e kua he raraunga, e whakamahatia Excel te tau e 100 me tāpiri te tohu% i te mutunga. arata'i tenei ki whakama, kia me āta ki te matau koutou te mea kei te tupu.

Kia mea a e patopato koe 10 i roto i te A2 pūtau, a ka tono te hōputu%. No te mea whakaatu Excel te maha o taurea o te 100 ki te whakaatu i te reira rite te ōrau (mahara e 1% - he kotahi wahi i roto i te rau i tenei), ka kite koutou e whakaaturia 1000% e i roto i te pūtau, kaua ki te 10%. Hei te mahi a tawhio noa tenei raruraru, ka taea e koe te tātai tona uara rite te ōrau i roto i te wahi tuatahi. Hei tauira, ki te tomo koutou te tātai = 10/100 A2, ka hoatu Excel te hua rite 0.1 pūtau. Ki te taea Na koe te whakahōputu te raraunga ira, ka whakaaturia te maha rite 10% - rite koutou e mahara. taea hoki e koe te tomo noa te tau i roto i te puka ira tika ki te pūtau, e ko, ki te tomo 0.1, a ka tono te hōputu ōrau. E tauturu i tenei i roto i te take, ki te mea e rapu ana koutou mo ha faingamālie, pera i roto i "Excel" tāpiri moni tango atu mahi ki a ratou ranei.

hōputu pūtau kau: e mahi Excel rerekē ina hōputu koe he pūtau mua-kau, a ka tomo i te tau. Numbers rite ki a nui atu i te 1, e tahuri ki te moni taunoa; E whakanuia ngā tau iti iho i te 1, e kore e kino e, e 100 ki te tahuri ratou ki ōrau. Hei tauira, ki te pato koe 10 ranei 0.1 i roto i te pūtau whakahōputu, ka taea e koe te kite i puta te uara o te 10%. Na, ki te pato koe 0.1, ka kite koutou i e i te huringa uara whakaaturia. Ka taea hoki te whakaatu te reira koe e founga ki "Eksele" tango moni.

Hōputu rite pato koe: Ki te tomo koutou te 10% tika ki te pūtau, Excel ka tono aunoa i te hōputu ōrau. Ko te pai tenei ina e hiahia ana koe ki te tomo tetahi anake ōrau i runga i te pepa, hei tauira, te nui o te pupirikana ranei kōmihana.

tauākī moni

Kia pehea te a ka tomo koutou i tetahi tātai ki Excel, whai koe ki te tīmata te tuhi i te uara, te pato i te tohu rite (=) i roto i te pūtau tīpakohia. Ko te tātai taketake o te āhua o te "Eksele" tatau titiro moni rite tenei: = B2 / C2.

e kia tētahi atu tauira tātai atu uaua. Na, ki te hiahia koe ki te whakaiti i te nui etahi ki te 25%, ka ngana koe ki te tono i te hekenga, ka whiwhi koutou tātai te puka e whai ake nei: = B2 * (1-C2). Ki te whakanui i te taha o te 25%, kia whakakapia e te tohu tango i roto i te tātai i roto i te tāpiri.