Hi

=MIN(LEN(A4),2)

However, since you didn't tell us what to do if len=2, I choose to treat it
as =2

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Perplexed" wrote:

I have a field with varying number of characters, I need function that
returns a value based on the number of characters in field.

ie if field x <2 characters = 1 2 characters = 2

Thanks