"Return text"

[Stuck2]

Hi,

Hopefully someone can help with this one - I have a list in a column which has either #N/A in each cell OR a 4 digit number. Those cells with #N/A in them, I know that it represents somebody who has not booked on duty. Those cells with a 4 digit number in them, I know that it represents somebody who has booked on duty.

I therefore want a formula to return "Booked On" if there is a 4 digit number in the cell and "Not Booked On" if the cell reads #N/A.

My list is in column L6:L151 - I will put the new formula in column M6:M151.

Any help appreciated!

Many thanks.

 

[VoG]

Try

=IF(ISNA(L6),"Not booked on","Booked on")

 

[Stuck2]

That's worked. Brill, thank you very much.