=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