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 |
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 |