Display thrid letter formula

[koba]

Hi All

I need a formula that displays an outcome. If the third letter of cell
A1 has a ‘D’ then display OK, otherwise display BAD

Please help

Thanks
Andrew

 

[Biff]

Hi!

Try this:

=IF(MID(A1,3,1)="D","OK","Bad")

Biff

 

[Rowan Drummond]

Try:

=IF(MID(A1,3,1)="D","OK","BAD")

Hope this helps
Rowan

 

[Roger Govier]

Hi Andrew

Try
=IF(A1="","",IF(MID(A1,3,1)="D","OK","BAD"))

Regards

Roger Govier

 

[koba]

Thanks worked a trea