View Single Post
 
Old 01-20-2015, 10:06 AM
AClaborn AClaborn is offline Windows XP Office 2010 32bit
Novice
 
Join Date: Oct 2013
Posts: 4
AClaborn is on a distinguished road
Default 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!
Reply With Quote