Quick one(I think!), LEN & IF
 

Hi,

does anyone know if its possible to incorporate the IF and LEN
statements,

I'm trying to say, IF the field is over 62 characters in Legth, show 1,
or show 0 if its under.

I tried various, =IF(A162,1,0) but that doesn't work, do I need to use
the LEN statement somewhere also?

Thanks for any help, much appreciated.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=523611

Quick one(I think!), LEN & IF
 

=IF(LEN(A1)62,1,0)

--
Kind regards,

Niek Otten

"saybut" wrote in message
...

Hi,

does anyone know if its possible to incorporate the IF and LEN
statements,

I'm trying to say, IF the field is over 62 characters in Legth, show 1,
or show 0 if its under.

I tried various, =IF(A162,1,0) but that doesn't work, do I need to use
the LEN statement somewhere also?

Thanks for any help, much appreciated.


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=523611

Quick one(I think!), LEN & IF
 

Try this...

=IF(LEN(A1)62, 1, 0)


--
kraljb
------------------------------------------------------------------------
kraljb's Profile: http://www.excelforum.com/member.php...fo&userid=9955
View this thread: http://www.excelforum.com/showthread...hreadid=523611

Quick one(I think!), LEN & IF
 

Ah that's brilliant, thanks.. I didn't realise you need to include the
LEN in sperate brackets.

thanks a lot


--
saybut
------------------------------------------------------------------------
saybut's Profile: http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=523611

Quick one(I think!), LEN & IF
 

Hi

Try this:
=IF(LEN(A1)62,1,0)

Andy.

"saybut" wrote in
message ...

Hi,

does anyone know if its possible to incorporate the IF and LEN
statements,

I'm trying to say, IF the field is over 62 characters in Legth, show 1,
or show 0 if its under.

I tried various, =IF(A162,1,0) but that doesn't work, do I need to use
the LEN statement somewhere also?

Thanks for any help, much appreciated.


--
saybut
------------------------------------------------------------------------
saybut's Profile:
http://www.excelforum.com/member.php...fo&userid=5949
View this thread: http://www.excelforum.com/showthread...hreadid=523611