LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 10
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
concatenate & conditional formatting in one jpennabeck Excel Discussion (Misc queries) 1 September 4th 08 07:26 PM
Concatenate and Conditional Formatting Sliver Rayne Excel Discussion (Misc queries) 1 January 9th 08 05:01 PM
CONCATENATE Formula jtinne Excel Discussion (Misc queries) 4 June 19th 07 06:54 PM
Conditional Concatenate ExcelMonkey Excel Worksheet Functions 3 April 18th 06 02:30 PM
Evaluating results of a concatenate formula, as a formula dodger Excel Worksheet Functions 5 September 9th 05 01:55 PM


All times are GMT +1. The time now is 05:12 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"