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
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
Hi!
Try this:
=IF(MID(A1,3,1)="D","OK","Bad")
Biff
"koba" <[email protected]> wrote in message
news:[email protected]...
>
> 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
>
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
>
>
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
>
>
Thanks worked a treat
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks