IF Statement with cells containing N/A

[nmetcal2]

I'm trying to use an IF Statement in my worksheet.

The rows contain numerous dates and the odd cell contains #N/A.

The formula I'm currently using is;

=IF(ISNA(I6:X6),"Incomplete","Complete")

What I want to happen is for the cell to return either Incomplete if the cell within the range contains #N/A or Complete is it doesn't.

Whilst this works when referencing one cell it doesn't want to work over a range of cells.

Any help would be appreciated.

Thanks.

[Sam Capricci]

how about =IF(COUNTIF(I6:X6,"#N/A"),"incomplete","complete")

EDIT: could also work w/o quotes =IF(COUNTIF(I6:X6,#N/A),"incomplete","complete")

[nmetcal2]

Awesome, that worked right away.

Thank you for the quick response, I'd been racking my brain for a while trying different combinations but didn't think to use a COUNTIF.

[Sam Capricci]

Great! Glad it worked for you, sometimes it just takes a different set of eyes to see something you've missed, happened to me many times.
Don't forget to mark your post as solved using the thread tools dropdown at the top of this post.
And thank you for the reputation!