Mara nyingi unataka kuangalia kama maadili mawili ya cells ni sawa kabisa, ikiwa ni pamoja na capital letters. Excel inatoa formula rahisi ya kufanya hivyo:

=IF(EXACT(H2,I2),Q$1,R$1)

📘 Maana ya Formula Hii

EXACT(H2,I2)

Inachunguza kama value ya H2 na I2 ni sawa kabisa, ikizingatia case sensitivity.

Inarudisha TRUE kama zinafanana, FALSE kama hazifani.

IF(EXACT(H2,I2), Q$1, R$1)

Ikiwa cells ziko sawa (TRUE), inarudisha value ya Q1.

Ikiwa cells haziko sawa (FALSE), inarudisha value ya R1.

🎯 Mfano Rahisi
H2 I2 Formula Result (=IF(EXACT(H2,I2),Q$1,R$1))
Apple Apple Q1 value
apple Apple R1 value
Banana Banana Q1 value
Banana BANANA R1 value

Kumbuka: EXACT ni case sensitive, hivyo "Apple" ≠ "apple".

🔗 Links 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