"Bernard Liengme" wrote in message
...
Your formula works when entered as an array formula - use CTRL+SHIFT+ENTER
to conform the formula.
(I assume your county uses ; for argument separation)
It this does not work make sure you have single letters in O; for example
does =O3="M" return TRUE?
best wishes

OMG thnak you ppl

yes ; is the separator in my country