Quick one(I think!), LEN & IF

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
 
S

saybut

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

thanks a lo
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Error message is Character Limit is over 1024 characters 2
Expensive Cameras 2
Len and InStr problem manipulating strings 3
Function problems 9
Computing percent changes in Excel between two values 2
Tag Numbers 7
Access How to remove a non-existent field from a form's Field List 0
Removing text in combo with anther FIND function 4

Top