Make certain when you enter the condition in the formula that it is surrounded by single or double quotation marks.
Kufanya baadhi ya wakati wewe kuingia hali katika formula kwamba ni kuzungukwa na alama moja au mbili quotation.