asked on
I'm trying to use an IF statement with nested IF's, and I also want to return TWO cells for the TRUE parts of my statements; i.e., for the first IF, I want cells C3 and C4 and then a comma and space after that. However, it doesn't seem to be picking up all the data; it's like picking up only the first column that has a number larger than 0 and then the last column, Column K. Here's my IF statement:
=IF(C4>0,$C$3&C4&", ",IF(D4>0,$D$3&D4&", ",IF(E4>0,$E$3&E4&", ",IF(F4>0,$F$3&F4&", ",IF(G4>0,$G$3&G4&", ",IF(H4>0,$H$3&H4&", ",IF(I4>0,$I$3&I4&", "," ")))))))&(IF(J4>0,$J$3&J4&
=IF(C4>0,$C$3&C4&", ",IF(D4>0,$D$3&D4&", ",IF(E4>0,$E$3&E4&", ",IF(F4>0,$F$3&F4&", ",IF(G4>0,$G$3&G4&", ",IF(H4>0,$H$3&H4&", ",IF(I4>0,$I$3&I4&", "," ")))))))&(IF(J4>0,$J$3&J4&
Learn from the best
Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.
Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 8 Comments.
Try for 7 days”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.
Our community of experts have been thoroughly vetted for their expertise and industry experience.