return true or false if cell contains comment.

I have comments in the cell, the comments are unique (1. abc) and (2. abc). so i just want to return true if the cell comment says (1. abc) and false if the cell comment says (2. abc). please guide me.

=IF(A1="1. abc",TRUE,IF(A1="2. abc",FALSE,""))

no its not text inside the cell, i said, its comment (when you right click on the cell you get insert comment)

Then I'm quite sure you will have to do some VBA macro programming. It would take me a while to work out the code. Others here probably could help you easier.

This UDF will return true if the cell provide for the parameter has a comment or false if not.

You could put this in your workbook code modules or your personal.xls if you want it available to all open workbooks.

It is volatile, so will re-calc when the workbook does, but if it is the only function and inserting a comment does not force a re-calc, you may wish to put a =Now() function somewhere to force a calc?

Public Function CellHasComment(TestCell As Range) As Boolean
Dim cmt As Comment
Application.Volatile True
Set cmt = TestCell.Comment
If Not cmt Is Nothing Then
    CellHasComment = True
Else
    CellHasComment = False
End If
End Function

And borrowing from Nick's code, if you want to find out what the comment text itself is, you could use this:

Public Function GetCellComment(TestCell As Range) As String
    Dim cmt As Comment
    Application.Volatile True
    Set cmt = TestCell.Comment
    If Not cmt Is Nothing Then
        GetCellComment = cmt.Text
    Else
        GetCellComment = ""
    End If
End Function