Kutumia NOT Kuangalia Sharti Lisilo Sahihi Katika Excel

Wakati mwingine unataka kuangalia kama sharti halitimizwi, Excel inatoa formula NOT. Kwa mfano:

=NOT(H2+I2=50)

📘 Maana ya Formula

H2+I2=50

Hii inatathmini kama jumla ya H2 na I2 ni sawa na 50.

Matokeo: TRUE ikiwa jumla ni 50, FALSE vinginevyo.

NOT(H2+I2=50)

Inabadilisha matokeo:

Ikiwa jumla ni 50 → FALSE

Ikiwa jumla siyo 50 → TRUE

🔹 Mfano:
H2 I2 H2+I2=50 NOT(H2+I2=50)
30 20 TRUE FALSE
25 10 FALSE TRUE
40 15 FALSE TRUE

Hii ni muhimu wakati unataka kuangalia exception cases au sharti lisilo sahihi katika grading system au budgeting.

🔗 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