Check if cells have number and if they do add each cells header to another single cell

[malaki1974]

Hello,

I wrote a code snippet that checks a cell for a number value (any number value), and if it finds it the header of that cell appears in another cell. What I want to do is nest (?) additional cell checks so that the final cell has all of the headers.

=IF(ISNUMBER(C3),C2&",","NO")

C3 might contain a number, if it does add the header to I3. In this example I3 now says "GROSS SF,".

I want to extend this to read something like:
=IF(ISNUMBER(C3),C2&",","NO") AND IF(ISNUMBER(D3),D2&",","NO") etc so I3 would now say "GROSS SF, RETAIL SF,"

How can I accomplish this?

 

[mathchick]

If I understand correctly you can just stick "&" between them to concatenate them into one string.