Quick one(I think!), LEN & IF

  • Thread starter Thread starter saybut
  • Start date Start date
S

saybut

Hi,

does anyone know if its possible to incorporate the IF and LE
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(A1>62,1,0) but that doesn't work, do I need to us
the LEN statement somewhere also?

Thanks for any help, much appreciated
 
Ah that's brilliant, thanks.. I didn't realise you need to include th
LEN in sperate brackets.

thanks a lo
 
Back
Top