| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Can a formula display output to an otherwise blank cell? | Excel Worksheet Functions | |||
| Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
| Search and Display Formula | Excel Discussion (Misc queries) | |||
| Formula checking multiple worksheets | Excel Worksheet Functions | |||
| Modifying a Formula To display only Unique Values | Excel Worksheet Functions | |||
Linear Mode
