View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
James T James T is offline
external usenet poster
 
Posts: 14
Default Using IF based on an LEN field

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