Display thrid letter formula
 

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

Display thrid letter formula
 

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

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

Display thrid letter formula
 

Hi Andrew

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

Regards

Roger Govier


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

Display thrid letter formula
 

Thanks worked a treat


--
koba
------------------------------------------------------------------------
koba's Profile: http://www.excelforum.com/member.php...o&userid=28639
View this thread: http://www.excelforum.com/showthread...hreadid=489315