Microsoft Office Forums Nest IF statements with a text comma inbetween each IF statement

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 01-20-2015, 10:06 AM
AClaborn AClaborn is offline Nest IF statements with a text comma inbetween each IF statement Windows XP Nest IF statements with a text comma inbetween each IF statement Office 2010 32bit
Novice
Nest IF statements with a text comma inbetween each IF statement
 
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
  #2  
Old 01-20-2015, 10:41 AM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline Nest IF statements with a text comma inbetween each IF statement Windows 7 64bit Nest IF statements with a text comma inbetween each IF statement Office 2010 64bit
Moderator
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,387
Pecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of lightPecoflyer is a glorious beacon of light
Default

Like this ?
Code:
=IF(J19>1,J19&",",)&IF(J20>1,J20&", ",)&IF(J21>1,J21&", ",)&IF(J22>1,J22,)
__________________
Problem solved ? Let others know by clicking " Thread Tools" then " Mark thread as solved".( This can be undone if need be)
Want to thank for the help received ? Click the scales symbol in the upper right corner of a post from the person you want to thank.
Reply With Quote
  #3  
Old 01-20-2015, 12:07 PM
AClaborn AClaborn is offline Nest IF statements with a text comma inbetween each IF statement Windows XP Nest IF statements with a text comma inbetween each IF statement Office 2010 32bit
Novice
Nest IF statements with a text comma inbetween each IF statement
 
Join Date: Oct 2013
Posts: 4
AClaborn is on a distinguished road
Default

Thank you! That worked exactly how I need it to; I really appreciate it.
Reply With Quote
Reply

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
Nest IF statements with a text comma inbetween each IF statement Add a comma mbesspiata Excel 7 06-09-2014 03:36 AM
Nest IF statements with a text comma inbetween each IF statement 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
Nest IF statements with a text comma inbetween each IF statement IF statement that adds text to a cell themangoagent Mail Merge 4 08-26-2009 08:07 AM


All times are GMT -7. The time now is 01:41 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2019, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2019 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft