Hi all.
I have attached a document showing a issue i have when i am trying to do an 'IF' formula when there is Concatenate used in a cell.
If someone could have a look at it for me and recommend a different term or way of making this work that will be great.
Thanks
What are you trying to accomplish? By using Concatenate, you are making it a text cell. Excel is comparing two text values together, not looking at the numbers.
Why are you using Concatenate on just one cell? Proof of principle? If you let us know what you are trying to accomplish, perhaps we can find a better solution.
If I helped you, please give me reputation.
Why are you using the CONCATENATE functions like that?
The problem is that the CONCATENATE function returns a TEXT value even if it looks like a number.
In Excel the TEXT value 18 is greater than the TEXT value 170 so your IF function is returning the correct result even though that's not the result you probably expect.
Biff
Microsoft MVP Excel
Keep It Simple Stupid
Let's Go Pens. We Want The Cup.
First off, when you use Concatenate, you are creating a Text value, not a number, so if you wrap VALUE() around it, or mutiply it by 1, or =--Concatenate(, it will be a value your if statement can properly use
(I'm assuming the single value in the concatenate was for demonstration purposes only )
Hope this helps
A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
-Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
-To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
If you received helpful response, please remember to hit the * of that post
Hi all,
Yes quite silly of me to use Concatenate. Using Value(..) works like a treat. Thanks for all your quite responses.
It's not clear what you're wanting to do but you seem satisfied.
Good luck!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks