IF formula to flag 'record types'

I need an IF formula to display TRUE or FALSE depending on what text is
contained in a cell.

Eg. Column J Contains differnt record types:

'New Agreement'
'Expiring (URGENT)'
'Completed'
'Pending'
'Cancelled'

I need a formula to look up this row & display True IF it contains
either of these 3 record types: New Agreement, Expiring (URGENT) &
'Pending'

I tried this, it's completely wrong I know, but it might give u a
better idea of what im looking for:

=IF(J2='Agreement',OR,'Expiring (URGENT)',OR,'New
Agreement',TRUE,FALSE)

*** Can you include brackets as text in a formula?


---
Message posted from http://www.ExcelForum.com/

Try changing your formula to :
=IF(OR(J2="New Agreement",OR(J2="Expiring
(URGENT)",J2="Completed")),TRUE,FALSE)

hth

Mike


---
Message posted from http://www.ExcelForum.com/

A little more concise, plus a typo in the last argument:

=OR(J2="New Agreement",J2="Expiring(URGENT)",J2="Pending")
--

HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"Freemini " wrote in message
...
Try changing your formula to :
=IF(OR(J2="New Agreement",OR(J2="Expiring
(URGENT)",J2="Completed")),TRUE,FALSE)

hth

Mike


---
Message posted from http://www.ExcelForum.com/