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!
|