Nest IF statements with a text comma inbetween each IF statement

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

FAQ

Thread Tools

Display Modes

01-20-2015, 10:41 AM

Pecoflyer

Windows 7 64bit Nest IF statements with a text comma inbetween each IF statement

Office 2010 64bit

Expert

Join Date: Nov 2011

Location: Brussels Belgium

Posts: 2,948

Pecoflyer has a reputation beyond repute

Like this ?

Code:

=IF(J19>1,J19&",",)&IF(J20>1,J20&", ",)&IF(J21>1,J21&", ",)&IF(J22>1,J22,)

__________________
Using O365 v2503 - 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

« Previous Thread | Next Thread »

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

Other Forums: Access Forums

All times are GMT -7. The time now is 11:51 PM.