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!

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


On Jun 26, 12:11*pm, Bullocks wrote:
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!

Thanks Ken!!!!!

You are amazing.

Cheers,
Graeme