Thread
: [Solved]
Nest IF statements with a text comma inbetween each IF statement
View Single Post
01-20-2015, 10:41 AM
Pecoflyer
Windows 7 64bit
Office 2010 64bit
Expert
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
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
Pecoflyer
View Public Profile
Find all posts by Pecoflyer