Display thrid letter formula
Try:
=IF(MID(A1,3,1)="D","OK","BAD")
Hope this helps
Rowan
koba wrote:
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
|