Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditional =CONCATENATE formula
Can't get my head around this one (perhaps it's just Friday!)
Cell B15 has a simple formula (Adding two cells) Cell B16 shaves off a couple of numbers number =CONCATENATE(RIGHT (B15,3)) B17 has a number I want to match with the shaved off number in B16 But when I try to add to that a conditional statement... =IF(B17<B16,"match","no match") Eg... A1: 1221 A2: 1 B15: = A1+A2 B16: =CONCATENATE(RIGHT(B15,3)) [yelids 222] B17: 223 B18 =IF(B17<B16,"match","no match") I shoud get "no match" in B18 [222 does not equal 223) but I get the same value no matter what is in B16 or B17. Is the concatenate formula causing a problem? I know the sum feature does not work with it. Thanks in advance to any wiz who can figure this one out! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
concatenate & conditional formatting in one | Excel Discussion (Misc queries) | |||
Concatenate and Conditional Formatting | Excel Discussion (Misc queries) | |||
CONCATENATE Formula | Excel Discussion (Misc queries) | |||
Conditional Concatenate | Excel Worksheet Functions | |||
Evaluating results of a concatenate formula, as a formula | Excel Worksheet Functions |