#1
|
|||
|
|||
Nest IF statements with a text comma inbetween each IF statement
I just need a comma to be displayed after each TRUE statement. Here is my nested IF statement; which works great except all of my True statements are all run together and I would like a comma space character in between them. I have tried added in ", " before the &IF and in the TRUE Value portion of the IF statement but I keep getting errors. Please let me know your thoughts.
=IF(J19>1,J19,)&IF(J20>1,J20,)&IF(J21>1,J21,)&IF(J 22>1,J22,) Here is an example of my data 174526 0 0 174527 and I would like the IF statement above to display the results like this: 174526, 174527 Currently it displays the results like this: 174526174527 Thanks! |
#2
|
||||
|
||||
Like this ?
Code:
=IF(J19>1,J19&",",)&IF(J20>1,J20&", ",)&IF(J21>1,J21&", ",)&IF(J22>1,J22,)
__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post |
#3
|
|||
|
|||
Thank you! That worked exactly how I need it to; I really appreciate it.
|
Thread Tools | |
Display Modes | |
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Mailmerge certain text using multiple if statements | Debs | Mail Merge | 4 | 06-19-2014 03:34 AM |
Add a comma | mbesspiata | Excel | 7 | 06-09-2014 03:36 AM |
DRop down list within text of If statement | sbarron76 | Mail Merge | 2 | 05-03-2013 05:00 AM |
Trouble with spacing inbetween words. | riff88 | Word | 3 | 12-21-2009 12:29 AM |
IF statement that adds text to a cell | themangoagent | Mail Merge | 4 | 08-26-2009 08:07 AM |