4) Cell A4 = if(Len(A3=7),"lower","greater)
The last equation does not seem to work.

Try it like this:

=IF(LEN(A3)=7,"lower","greater")

Biff

"James T" wrote in message
...
Best way to describe to to explain the data I think:

1) Cell A1 = 505
2) Cell A2 = 506
3) Cell A3 = A1 & ", " & A2
4) Cell A4 = if(Len(A3=7),"lower","greater)

The last equation does not seem to work.

I can only assume this is because it is trying to determine the length of
another equation and cannot cope (my assumption here).

Any ideas how I can get this to work for me?

Regards

James