tryin to if function with OR and AND

MazU

Hi All,

If there is a date in 'date found' column and date in 'Date collected' column, Column7=Collected

if there is a date in 'date found' column but no date 'Date collected' column, column 7=Uncollected

if the 'Date found' column is blank, column7=blank

Can anyone please try help

@Genevieve P.

@Paul Newcome

can you please assist me, i would appreciate it a lot

Paul Newcome

Try something like this:

=IF([Date Found]@row <> "", IF([Date Collected]@row <> "", "Collected", "Uncollected"))

MazU

@Paul Newcome

Thank you Paul, really appreciate your response.

I actually managed to do using a different formula but yours is way more simpler

=IF(ISBLANK([Date Found]@row), "", IF(AND(ISDATE([Date Found]@row), ISDATE([Date Collected]@row)), "Collected", "Not Collected"))

Thanks once again