=IF Function Not Working

[jllogan111]

Please help:

I have a spreadsheet that has site numbers listed in the far left column, then there are 8 columns to the right. Each of the 8 columns represents a Visit # and the cell is filled in with the date, like so:

Site # Visit 1 Visit 2 Visit 3 Visit 4
1001 08/20/08 LATE! 10/31/08 LATE!
1002 04/21/08 05/16/08 LATE! 07/21/08
1003 LATE! 02/21/08 03/15/08 LATE!

I need a formula that will look in each of the cells and if it finds a "LATE!" , it places an X in the cell, if not, it places a blank or a zero. I had the formula as:

=if(b1:b4="LATE!","X",0)

It keeps returning an error because it is calculating the total of all of the cells instead of looking into each cell. I tried to spell it out like:

=if(b1,b2,b3,b4="LATE!","X",0)

That didn't work either. HELP!

[oldchippy]

Hi,

Try this,

=IF(COUNTIF(A1:D1,"LATE")>=1,"X",0)

or

=IF(COUNTIF(A1:D1,"LATE")>=1,"X","")

[arthurbr]

Hi,
where exactly do you want the information ? in the last cell to the right of the row?
If so try =if(countif(b1:b4,"late!")>0,"late!",0)

[arthurbr]

Eagle Eye, you're mighty fast !