IF

takemp · Mar 13th, 2002, 07:17 AM

I want to have a true/false result if the cell contains text, eg if(B4 contains text, 1,0). Is this poss?

Thanks

Thanks guys for the introduction to the world of IS

[ This Message was edited by: takemp on 2002-03-13 08:11 ]

[ This Message was edited by: takemp on 2002-03-13 08:12 ]

Mudface · Mar 13th, 2002, 07:26 AM

Just type in (for example): -

=ISTEXT(A1)

Mark W. · Mar 13th, 2002, 07:37 AM

Quote:

On 2002-03-13 06:17, takemp wrote:
I want to have a true/false result if the cell contains text, eg if(B4 contains text, 1,0). Is this poss?

Thanks

If you need {1,0} rather than {TRUE,FALSE} you can coerce the results using an arithmetic operator...

=ISTEXT(A1)+0

Thread Tools
Show Printable Version Email this Page
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Mar 13th, 2002, 07:17 AM	#1
takemp New Member Join Date: Mar 2002 Posts: 2	I want to have a true/false result if the cell contains text, eg if(B4 contains text, 1,0). Is this poss? Thanks Thanks guys for the introduction to the world of IS [ This Message was edited by: takemp on 2002-03-13 08:11 ] [ This Message was edited by: takemp on 2002-03-13 08:12 ]

Mar 13th, 2002, 07:26 AM	#2
Mudface MrExcel MVP Join Date: Feb 2002 Location: Sunny, spring-like Hull Posts: 3,339	Just type in (for example): - =ISTEXT(A1)