Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF based on an LEN field
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Using IF based on an LEN field
For your example, the length would be 8 since you have two numbers of length
3 and concatenate in two characters - a comma and a space. Perhaps you want something like this = if(Len(A3)=7,"lower","greater") Biff gave you the correction for =7, but it seems slightly odd that your example wouldn't pass the test. Hard to say. -- Regards, Tom Ogilvy "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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to change field settings in calculated field in a pivot tab | Excel Discussion (Misc queries) | |||
Populating a field based on lookup values | Excel Worksheet Functions | |||
Sum based on value in another field | Excel Worksheet Functions | |||
Pivot Table Calculated field item | Excel Discussion (Misc queries) | |||
Formula pull factor from chart based on value of diff field? | Excel Worksheet Functions |