Hi!
Try this:
=IF(MID(A1,3,1)="D","OK","Bad")
Biff
"koba" wrote in message
...
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
--
koba
------------------------------------------------------------------------
koba's Profile:
http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=489315