Kutambua Aina ya Data Kwenye Excel Kutumia IF + ISTEXT + ISNUMBER + ISBLANK

Wakati unafanya kazi na Excel, mara nyingi unahitaji kuchambua data kulingana na aina yake: text, number, au empty cell. Formula ya IF + ISTEXT + ISNUMBER + ISBLANK inafanya hili kuwa rahisi.

=IF(ISTEXT(R2),T$1,IF(ISNUMBER(R2),U$1,IF(ISBLANK(R2),V$1,"")))

📘 Maana ya Formula Hii
✔ 1. ISTEXT(R2)

Inachunguza kama cell R2 ina text.

Ikiwa kweli, inarudisha thamani ya T1 (mfano: "Text").

✔ 2. ISNUMBER(R2)

Ikiwa si text, inachunguza kama ni number.

Ikiwa kweli, inarudisha thamani ya U1 (mfano: "Number").

✔ 3. ISBLANK(R2)

Ikiwa si text wala number, inachunguza kama ni empty cell.

Ikiwa kweli, inarudisha thamani ya V1 (mfano: "Blank").

✔ 4. ""

Ikiwa hakuna hali iliyokidhiwa, inarudisha blank string.

🎯 Mfano Rahisi
Cell R2 Matokeo (Formula)
Hello Text
123 Number
Blank
TRUE ""

Tumia formula kama hii:

=IF(ISTEXT(R2),T$1,IF(ISNUMBER(R2),U$1,IF(ISBLANK(R2),V$1,"")))

Ili kuonyesha matokeo sahihi kwenye cells tofauti.

🔗 Links Muhimu Za Kujifunza Zaidi

🌐 Faulink Official Website:
https://www.faulink.com/

📘 Excel Mifumo – Ready to Use:
https://www.faulink.com/excel_mifumo.php

📲 Piga / WhatsApp kwa msaada wa haraka:
https://wa.me/255693118509

🧩 Hitimisho

Formula hii ya IF + ISTEXT + ISNUMBER + ISBLANK ni rahisi, haraka, na ya nguvu kwa kuchambua data kwenye Excel.
Inafaa kwa data cleansing, report analysis, au validation ya aina ya data.