Me pehea te tirotiro mena kei te putua tetahi pūtau ma te whakamahi ISBLANK i Excel:
ISBLANKMa tenei mahi a Microsoft Excel ka taea e koe te tirotiro mena kei te putua tetahi pūtau, kaore ranei. Ka taea e koe te whakamahi i tenei mahi me IFKo te mahi ki te whakatau he aha nga mea ka pa ki o pūtau i te wa e putu ana, karekau ranei. Anei me pehea te mahi.
He aha te mahi ISBLANK i Excel?
Ma te mahi Excel ka taea e koe ISBLANKKa taki mena kei te putua te pūtau kua tohua, kaore ranei. Mēnā kei te putua te pūtau, ka whakahoki te mahi TRUEUara. Ki te kore te pūtau i te putua, ka whiwhi koe FALSEUara. Ka taea e koe te whakamahi i enei uara me etahi atu mahi Excel, penei IF, ki te mahi i nga mahi ki runga, ki te whakautu ranei ki nga pūtau putua me te kore-putea.
tātai ISBLANKKo te mahi:
=ISBLANK(uara)
konei, valueHe tohu tohutoro pūtau e hiahia ana koe ki te taki. Na, ki te hiahia koe ki te tirotiro mena kei te noho kau te pūtau A1, ka whakauru koe A1Tuhinga o mua value.
Ka whakarato ano a Excel i etahi atu mahi mo te mahi me nga pūtau tuwhera, COUNTBLANKKei hea tenei ka hoatu ki a koe Te tapeke o nga pūtau putua i roto i te awhe kua tohua. Mena kua mohio koe mena kei te putua tetahi pūtau, kaore ranei engari kei te pirangi koe ki te mohio he aha te momo uara kei roto, ka taea e koe te whakamahi i nga mahi penei ISNUMBERTirohia mehemea kei roto i te pūtau kua tohua he nama, he nama ranei ISTEXTKa taki mena he uara kuputuhi kei roto i tetahi pūtau.
Tirohia mehemea kei te putua tetahi pūtau ma te whakamahi i te mahi ISBLANK a Excel
Hei whakamahi i te mahi, tuatahi, whakatuwhera i te ripanga me te tono Excel ka paato i te pūtau e hiahia ana koe ki te whakaatu i te hua o te mahi.
I roto i te pūtau kua homai, patohia te mahi e whai ake nei ka pa ki te tomo. I tenei mahi, whakakapi C2Ko te pūtau e hiahia ana koe ki te taki.
=ISBLANK(C2)
ki te whakamahi Tukuna mo o rekoata katoa I roto i te ripanga, mai i te kokonga matau-raro o te pūtau i uru ai koe ki te mahi, swipe ki raro kia kapi katoa o rarangi.
Inaianei kua mohio koe he aha te pūtau me te mea ehara i te pūtau putua i roto i to ripanga.
Mahia he hohenga ina he putua te pūtau, karekau ranei
I te nuinga o nga wa, ka hiahia pea koe Mahia he mahi i runga i te ahua o to waea . Ka hiahia pea koe ki te whakaatu i tetahi karere e kii ana i tetahi mea ina he putua to waea me te korero i tetahi atu korero ina karekau to pukoro i te putua.
Hei mahi i tenei, hanumi ISLBLANKmahi me te mahi Excel IF.
Tuatahi, whakatuwherahia to ripanga me Excel. Kātahi ka paato i te pūtau e hiahia ana koe ki te whakaatu i te hua o to mahi.
I roto i te pūtau kua homai, patohia te mahi e whai ake nei ka pa ki te tomo. Anei, whakakapi C2te pūtau e hiahia ana koe ki te taki (mehemea kei te putua, kaore ranei), Sale Not Mademe te kuputuhi e hiahia ana koe ki te whakamahi mena kei te putua te pūtau, Sale MadeA ma te kuputuhi mena karekau te pūtau i te putua.
=IF(ISBLANK(C2),"Kaore i mahia te Hoko","I Hangaia te Hoko")
Hei whakamahi i te mahi mo o rekoata katoa i roto i te ripanga, mai i te kokonga matau o raro o te pūtau i uru ai koe ki te mahi, swipe ki raro kia kapi katoa o rekoata.
Inaianei ka whakaatuhia te kuputuhi i tohua e koe mo nga pūtau putua me te kore-patea.
