IF formula to flag 'record types'

L

loscherland

I need an IF formula to display TRUE or FALSE depending on what text i
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 contain
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
better idea of what im looking for:

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

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

Freemini

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

hth

Mik
 
R

RagDyer

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!
==============================================


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

hth

Mike
 
Top