I teie mahana korero tatou e pā ana ki te mahi o Excel ripanga ētita, "Ki te." He ki te mahi ki nga taea arorau o te tono. Ka taea te pēnei te reira ki te mahi tino rongonui i roto i te mahi.
Āhuatanga matua
I roto i Excel, te tātai "Ki te" āwhina ki te mahi i katoa o ngā mahi, ina e hiahia ana koe ki te whakarite i etahi raraunga, me te whiwhi i te hua. hanga ana tēnei otinga reira taea ki te whakamahi i wana hātepe, a ka hanga i te rakau whakatau.
tauira o te whakamahi
rite tenei titiro te mahi: = IF (mahi; pono; teka). Ko te huānga tuatahi - he faaiteraa arorau. kia waiho te reira i te kīanga te tau ranei. Hei tauira, "10" ranei "waho" - ko te faaiteraa arorau. hiahiatia ana tēnei tawhā te ki kia whakakiia. Pono - Ko te uara e puta rite ki te hua, ki te he pono te faaiteraa. Takoto - te raraunga e ka tukuna kia ka kore e waiho tika te mahi.
tawhā Takatāpui o ngā pūtau e rua
Hei mahino nga mahi ka taea o "Ki te" ki Excel, he noa te tauira e tika ana, a ka neke matou i runga i ki te whakaaro a ratou. Rāwaho ki te pūtau C1 feruri 8. I tua atu, i te pouaka i D1 kua tomo whai tātai: = IF (C1 <10: 1; 2). Ko te kupu, ka whakarite i te hōtaka te uara o te tawhā C1 ngā pūtau 10. A, no te he reira iti iho i te kotahi tekau, puta he mara i runga i te D1 wae wāhitau. Kore, ka whakaatu i te ētita te tau 2. Fakakaukau ki tetahi atu raruraru. He he he rārangi o ngā ākonga, me ō rātou kaute whiwhi i runga i te whakamātautau. Ko enei e whai ake: 5, 4 me te 3, me 2. Ko te tikanga o te raruraru tā te hanga mo ia o nga ākonga i te kōrero kuputuhi "haere" ranei "e kore e haere". I roto i te mau parau te tahi atu, ki te i whakatau te ākonga e toru, me te ake, taukei ia te whakamātautau. Ki te he tana tapeke i raro 3 - e kore te ākonga i haere. Hei whakaoti i tēnei raruraru tuhituhi tatou te tātai e whai ake nei: = IF (C1 <3: "kahore runanga", "haere"). ka timata Excel ki whakarite te hua o ia o nga ākonga. A, no te te taupū he iti iho i te e toru (ie rua) i roto i te pouaka e tika ana kia tohua kōrero "kihai i whakaora." Ki te te score - 3 me runga ake, ka tohu i te pouaka e hiahiatia ana e haere te ākonga te whakamātautau. fakamatala Kuputuhi Me whakapūtā tonu koe i roto i kōrero. E ai ki taua parau tumu o mahi ohie tātai Excel "Ki te". I roto i tona whakamahi, he reira taea ki te tono i taua ngā whakarite: <> =,>, <,> =, <=.
Tauira o te tono i te "RĀNEI" tikanga "e ahau"
tonu tatou ki te mahi me te rangatira i te arorau o te tono. Excel ripanga ētita mahi "Ki te" taea te ngā ki ngā whakarite. Ko nga tawhā enei: "OR", "AND". Tauwhāiti te huru e hiahiatia ana i roto i te Excel: ki te piro rite ki iti iho i te 5 ranei te äkonga, engari neke atu i te 3 kia whakaaturia tākupu: "whitinga". Te kore - ". Kahore" Na, haere anake aua ākonga nei riro me rima wha. mahi rite Tuhia i roto i te kaiwhakatika tepu e taea te whakamahi i te tātai motuhake. ka titiro te reira i rite ki tenei: = IF (AND (A1 <= 5: A1> 3); "whitinga", "kahore"). Hoki atu tauira matatini ngā te whakamahi o te "OR" ranei "AND". Na kia kite a e founga ki te tono i te tātai ki Excel, ki te he maha o ngā āhuatanga i roto i te raruraru. He tauira o te faaiteraa taua: = IF (RĀNEI (A1 = 5: A1 = 10): 100; 0). Mai i tenei whai reira e te mea te tohu i roto i te A1 pūtau he 5 ranei 10, whakaatu te hōtaka te hua 100 i roto i te take te ritenga - 0. taea te whakamahi i enei ngā me ki te whakaoti ngā mahi matatini ake. Hei tauira, he tika te pātengi raraunga ki te tātai i te hunga e hiahia ana ki te utu neke atu i te 10,000 moni. Heoi, e kore ratou e utu i te taurewa mo ono marama. Pānga Excel ripanga ētita, "Ki te" taea ki a koe te tohu aunoa i te ritenga atu te ingoa tēnā "kiritaki raruraru". Pea i roto i te pūtau A1 raraunga Kei tohu nama wā (marama). Whakaatu mara B1 te nui. I roto i tenei take, ka waiho i te tātai e whai ake: IF = (ahau (A1> = 6: B1> 10000); "kiritaki raruraru"; ""). whai te reira e te mea kitea he tangata e e ōrite ana te paearu tauwhāiti, ka whakaatu te hōtaka i roto i te mua o tona kōrero e hiahiatia ana ingoa. Hoki atu kaiuru katoa o te rārangi o te pūtau rite tonu kau. A feruri i te hi'oraa o te take te wahi he tino te āhuatanga. E tomo te tākupu tika. Ka rite ki te hua, e titiro te tātai rite tenei: = IF (RĀNEI (A1> = 6: B1> 10000); "he āhuatanga tino", ""). I roto i tenei take, ki te kitea e te hōtaka he ōrite hoki i te iti rawa tetahi o nga tawhā (wa, nui o te nama), ka kite i te kaiwhakamahi te tuhipoka hāngai. I roto i te āhuatanga tuatahi, whakaputaina te kupu "kiritaki raruraru" i anake ina kua tutaki e rua tikanga i tohua.
matatini mahi taumata-tiketike
Pānga Excel ripanga ētita, "Ki te" te whakamahia ki te hipa i te hapa hanga-i roto i ka wehewehe i te kore, me te rite i roto i te maha atu wā. tohua te āhuatanga tuatahi e te ētita rite "DIV / 0" me he tino noa. Te reira i te tikanga whakatika i roto i te wā i reira te tārua te tātai kia «A / B», ai te B wāhanga i roto i te pūtau takitahi ko te kore. Ka taea te karohia tenei i te kaiwhakahaere ki te whakapā atu i te pūrongo. Ko te kupu, ka waiho i te tātai tika ki te whai i te puka e whai ake: IF = (B1 = 0: 0: A1 / B1). whai te reira e te mea kua ki te B1 pūtau kei te ki te tawhā "kore", te ētita e puta i te "0", te kore wehe Excel wāhanga A1 ki raraunga B1 me whakaatu te hua.
hekenga
I roto i te mahi, maha puta me te āhuatanga, ka e kia kōrero i muri. Ko reira e pā ana ki te tātai pä, e hāngai ana i runga i te nui katoa o te moni i pau i runga i te rironga o etahi taonga. Whakamahia i roto i tenei take, ka taea e te kopu i te puka e whai ake nei: i te iti rawa 1000 - 0%; 1001-3000 - 3%; 3001-5000 - 5%; neke atu i te 5001 - 7%. A feruri i te āhuatanga te wahi i reira he he pātengi raraunga Excel o manuhiri, me te mōhiohio e pā ana ki te nui pau ratou i runga i te hoko o ngā rawa. Na e hiahia ana tatou ki te tātai i te hekenga mo ia kiritaki. Hoki tenei whakaaro, te whakamahi i tatou i te faaiteraa e whai ake nei :. = IF (te A1> = 5001; B1 * 0,93; IF (A1> = 3001; B1 * 0,95; ..) taki te pūnaha te nui katoa o te hoko, ina nui te reira i te ahua i roto i te 5001. moni, e whakanuia e 93 ōrau o te uara o te taonga. i roto i te take o te upooti'araa i te tohu o 3001 kōwae, i reira te mea he pānga rite, engari tango ki pūkete te 95%. taea te ngāwari hoatu te tātai i runga ki mahi. ko te rōrahi o hoko me pä tohu whakaturia e te kaiwhakamahi.
Ko te whakamahi o te āhuatanga whakaahuatia he taea hoki te otinga o ngā raruraru. Ko te atamira matua - faaineineraa tika o te tātai ki kore te tiki i te hua he. Na e matau ana koutou ki te whakamahi i te operator ki Excel, ki te he maha o ngā āhuatanga i roto i te raruraru.