LinkBack URL
About LinkBacks
So I have a formula as such =IF(P5,"Example",IF(P6,"Example2","")) but within these examples is more then 255 characters, and its asking to use the concentrate function. I've tried a few ways but none work. Any thoughts?
So I have a formula as such =IF(P5,"Example",IF(P6,"Example2","")) but within these examples is more then 255 characters, and its asking to use the concentrate function. I've tried a few ways but none work. Any thoughts?
Last edited by 6StringJazzer; 06-24-2014 at 03:36 PM. Reason: Fixed typo in thread title
Hi,
Can u explain a bit further what you need and what you are trying to do? Also, it would be helpful if you could provide us a workbook with sample data (remove sensitive information)
If my assistance has helped, there is a reputation icon * on the left hand corner below the post - you can show your appreciation to the user who has helped in resolving your requirement.
If your requirement has been solved please mark your thread as Solved.
In the menu bar above the very first post, select Thread Tools, then select "Mark this thread as Solved".
Kindly use [FORMULA] or [CODE] tags when posting your code.
Regards,
Sarang
Hi,
Are you perhaps meaning the Concatenate function? Would you also explain what your formula is attempting to do since the syntax is not familiar to me. Do you perhaps mean
Formula:
Please Login or Register to view this content.
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
Well the workbook is really nothing so far, but basically I have 2 checkboxes, one linked to p6 and the other to p7. If p6 = true it will reveal the hidden text associated with the p6 part of the formula, same on the p7 but a different hidden text within the same cell. The problem is there is over 255 characters within the text so I get the error.
I parsed it that P5 and P6 would return booleans; so that "Example1" occured if P5 was TRUE and it would pass to the second IF whenver P5 was FALSE, for example.
I dunno that's what's actually happening though?
EDIT:
ninja'd by OP
Well the workbook is really nothing so far, but basically I have 2 checkboxes, one linked to p6 and the other to p7. If p6 = true it will reveal the hidden text associated with the p6 part of the formula, same on the p7 but a different hidden text within the same cell. The problem is there is over 255 characters within the text so I get the error.
Perhaps you need something like
=IF(P5,"first255characters"&"another50characters",IF(P6,"first255characters"&"another12characters",""))
The & symbol is shorthand for concatenate.
or put the really long strings in their own cells, say Q5 and Q6
=IF(P5,Q5,IF(P6,Q6,""))
I had to tweak my worksheet but yea that works, thank you very much.
You're welcome.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks