Conditional =CONCATENATE formula

B

Bullocks

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

Ken

It seems a little counter intuitive that you would want to return
"match" any time the cells DO NOT match and "no match" when they are
the same; but, assuming that is the case the problem may come down to
the fact that the RIGHT(x,3) function returns a 3 character "string"
which may not match the value you compare it with, even if they look
the same. You can try =VALUE(CONCATENATE(RIGHT(B15,3)) and see if that
works better. It seems that the CONCATENATE function is extraneous
since you are not concatenating anything; but, it is harmless.

Good luck.

Ken
Norfolk, Va
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top