IF formula

[Lehany]

Hi,

I am trying to work out a formula for a training spreadsheet. I need to show whether all essential training has been completed. If the training is completed it will have a date in the completed column under the course name, if blank then it has not been completed.

So, I would need the formula to look in the cell range and if any blanks then it would return an 'N' as training has not all been completed. If no blanks in the range then a 'Y' should be returned.

Thanks.

[npatridge]

Try something like this:

=IF(COUNTIF(A1:A10,"")>0,"N","Y")

assuming your dates are in A1:A10 =)

[Lehany]

Ah, thank you very much. That works.