Hi Vicky,

That is not a formula from the link I gave. Please check the examples
carefully!

--
Kind regards,

Niek Otten

"Vic1978" wrote in
message ...

Hello,

unfortunately this function doesn´t work. There is always an error...

What is wrong with the formula?

=(COUNTIF(A2;"1"),TRUE,FALSE)

Kind regards,
Vicky


--
Vic1978
------------------------------------------------------------------------
Vic1978's Profile:
http://www.excelforum.com/member.php...o&userid=28708
View this thread: http://www.excelforum.com/showthread...hreadid=490744