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.
Bookmarks