I waena o nā hana he nui a Microsoft Excel e hana ai, pono e hōʻike ʻia ka hana IF. ʻO kēia kekahi o kēlā mau mea hoʻohana e hoʻohana pinepine ʻia e nā mea hoʻohana i ka wā e hana nei i nā hana i loko o ka noi. E nānā kā mākou i ke ʻano o ka IF, a pehea e hana pū ai me ia.
ʻO ka wehewehe nui a me nā pahuhopu
ʻO IF kahi hiʻohiʻona maʻamau o Microsoft Excel. Hoʻokomo kāna mau hana i ka hōʻoia ʻana i ka hoʻokō ʻana o kahi kūlana kūikawā. I ka hihia ke hoʻokō ʻia nā ʻano (ʻoiaʻiʻo), a laila ua hoʻihoʻi ʻia kēia waiwai i ke kelepona i hoʻohana ʻia ai kēia hana, a inā ʻaʻole i hoʻokō ʻia (wahaheʻe) - kekahi.
ʻO ka ʻaoʻao kahi o kēia hana: "IF (hōʻike logical; [waiwai inā pono]; [waiwai inā waha ʻole])."
Hōʻike kumu
ʻĀnō e nānā i nā hiʻohiʻona kikoʻī kahi e hoʻohana ʻia ai ke ʻano me ka huaʻōlelo IF.
He ʻai uku ko mākou. Ua loaʻa nā wahine a pau i ka bonus i ka lā Malaki 8 ma 1,000 rubles. ʻO ka papa i loaʻa kahi kolamu e hōʻike i ke ʻano o nā limahana. No laila, pono mākou e hōʻoia pono i ka lālani me ka waiwai o "nā wahine." i ka kolamu "Gender", ua hōʻike ʻia ka waiwai "1000" i loko o ka pūʻali kūpono o ka kolamu "Premium ma Malaki 8", a i nā laina me ka waiwai "kāne." i loko o nā kolamu "Loaʻa no Malaki 8" i kū i ka waiwai "0". E kā mākou hana i ke ʻano: "IF (B6 =" wahine. ";" 1000 ";" 0 ")."
E hoʻokomo i kēia hoʻolaha i ka puʻu kiʻekiʻe loa e hōʻike ʻia ai ka hopena. Ma mua o ka haʻi'ōlelo, kau i ka hōʻailona "=".
Ma hope o kēlā, kaomi i ka pihi Enter. I kēia, ke ʻike ʻia kēia alapine ma nā lalo liʻiliʻi, kū wale mākou i ka ʻaoʻao ʻākau ma lalo o ka kelepona piha, kaomi ma luna o ka pihi kiole, a e hoʻoneʻe i ka makeʻe i lalo o ka papaʻaina.
No laila, loaʻa iā mākou kahi papaʻaina me ka kolamu i piha i ka hana "IF".
Pākuʻina Hana me nā Kūnaea Kahi
Hiki iā ʻoe ke hoʻokomo i kekahi mau kūlana i ka hana IF. I kēia hihia, ua pili ʻia ka hoʻopili ʻia ʻana o ka ʻōlelo ʻo IF i kekahi. Ke hoʻokō ʻia ke kūlana, hōʻike ʻia ka hopena i hōʻike ʻia i loko o ka pūpū; inā ʻaʻole i hoʻokō ʻia ke ʻano, pili ka hopena i hōʻike ʻia ma ka lua.
Eia kahi laʻana, e lawe i ka papa papaʻaina me nā uku uku i ka lā 8 Malaki. Akā, i kēia manawa, e like me nā kūlana, ʻo ka nui o ka bonus ke hilinaʻi i ka māhele o ka limahana. Loaʻa i nā wahine me ke kūlana o nā limahana kumu he 1,000 rubles o ka bonus, aʻo nā limahana kākoʻo e loaʻa wale nō he 500 rubles. He kūlohelohe, no nā kāne ʻaʻole i ʻae ʻia kēia ʻano o ka uku o ka ʻae ʻana, me kahi kāwai.
Pēlā, ʻo ka mea mua he kāne inā he kāne ke kāne, a laila ua hapa ka nui o ka uku keu. Inā he hewa kēia waiwai, a ʻo ke kanaka ʻaʻole ke kāne (i.e. a wahine), laila ua hōʻoia ʻia ka lua o nā kūlana. Inā lilo ka wahine i ka limahana nui, a laila e hōʻike ʻia ka waiwai "1000" i loko o ka pūnaewele, a me nā mea "500". Ma ke ʻano o kahi hoʻohālikelike, e kūlike ʻia ia me kēia: "= IF (B6 =" male. ";" 0 "; IF (C6 =" Kahi kumu ";" 1000 ";" 500 "))".
E kāpīpī i kēia hōʻike i loko o ka hale kiʻekiʻe loa i ka kolamu "Malaki 8th."
E like me ka manawa hope, "huki mākou" i lalo i ka palapala.
ʻO kahi hiʻohiʻona o ka hoʻokōʻana i nā ʻano ʻelua i ka manawa like
Ma ka hana IF, hiki iā ʻoe ke hoʻohana pū i ka hui AND, e ʻae ana iā ʻoe e noʻonoʻo i kaʻoiaʻiʻo wale nō inā he ʻelua a ʻoi paha mau kūlana i hoʻokō ʻia i hoʻokahi manawa.
Penei, i kā mākou hihia, ʻo ka uku i ka lā 8 Malaki ma ka nui o 1000 rubles i hāʻawi ʻia i nā wāhine wale nō nā limahana nui, a ʻo nā kāne a me nā wāhine wahine i kākau inoa ʻia he limahana kōkua. No laila, no ka loaʻa ʻana o ka waiwai nui o nā kolamu o ka kolamu "Premium ma Malaki 8" i 1000, ʻelua mau kūlana e hui ʻia: ʻano wahine - wahine, nā kākāʻāinana o nā limahana. I nā hihia āpau a pau, e lilo ke kumu o kēia mau helu. Ua kākau ʻia kēia penei: "= IF (AND (B6 =" wahine. "; C6 =" limahana ʻoihana ");" 1000 ";" 0 ")." E hoʻokomo iā ia i loko o ka pūlau.
E like me ka wā ma mua, e kope i ka waiwai o ka pulu ʻana i nā puna ma lalo.
ʻO ka hiʻohiʻona o ka hoʻohana ʻana i ka mea hoʻohana OR
Hiki nō i ka hana IF ke hoʻohana pū i ka mea hana OR. I ka manao ia ua maoli ka waiwai ina he mea maona kekahi o kekahi mau kūlana.
No laila, manaʻo e ma ka lā Malaki 8, ua hoʻonoho ʻia ka makana i 100 rubles wale nō i nā wahine i waena o nā limahana nui. I kēia hihia, inā he kāne ke kāne, a no ia mea i kōkua o nā mea kōkua, a laila e lilo ka waiwai o kāna bonus, inā ʻaʻole 1000 rubles. Ma ke ʻano o kekahi ʻano hoʻohālike, ua like kēia: "= IF (KO (B6 =" male. "; C6 =" Kākoʻo kākoʻo ");" 0 ";" 1000 ")." Kuhi mākou i kēia ʻatikala i nā papa papa inoa.
"ʻUllleʻa" i lalo ka hopena.
E like me kāu e ʻike ai, hiki i ka hana "IF" ke lilo i mea kōkua maikaʻi no ka mea hoʻohana ke hana nei me ka ʻikepili ma Microsoft Excel. Hiki iā ʻoe ke hōʻike i nā hopena i kūpono i kekahi mau kūlana. ʻAʻohe mea paʻakikī loa i ka hoʻohana ʻana i nā loina o ka hoʻohana ʻana i kēia hana.
