Using Concatenate and If statements togehter

[TMCINNIS]

I would like to use an IF statement that will insert "No Comments Added" string where the concatenated cell is empty. Is this possible?

I need to stream line some worksheet process building reports for management. I only have one stumbling block left regarding the following formula:

=CONCATENATE("OCTOBER-",OCT!B51,"// NOVEMBER-",NOV!B51,"// DECEMBER-",DEC!B51,"// JANUARY-",JAN!B51,"// FEBRUARY-",FEB!B51,"// MARCH-",MAR!B51,"// APRIL-",APR!B51,"// MAY-",MAY!B51,"// JUNE-",JUN!B51,"// JULY-",JUL!B51,"// AUGUST-",AUG!B51,"// SEPTEMBER-",SEP!B51)

The purpose is to combine text fields containing notes from monthly reporting spreadsheets for on a roll up report. The // are visual separations of monthly data.

However the problem is that some months have no data. So the string returned is as follows below. I would like to use an IF statement that will insert "No Comments Added" string where the concatenated cell is empty.

OCTOBER-// NOVEMBER-Continuing coordination with ABC Communities to increase installations.// DECEMBER-// JANUARY-// FEBRUARY-// MARCH-// APRIL-// MAY-// JUNE-// JULY-// AUGUST-// SEPTEMBER-Installed a sizable commercial system for ABC Communities.

Is this possible?
Thanks.

 

[Fishboy]

I would like to use an IF statement that will insert "No Comments Added" string where the concatenated cell is empty. Is this possible?

I need to stream line some worksheet process building reports for management. I only have one stumbling block left regarding the following formula:

=CONCATENATE("OCTOBER-",OCT!B51,"// NOVEMBER-",NOV!B51,"// DECEMBER-",DEC!B51,"// JANUARY-",JAN!B51,"// FEBRUARY-",FEB!B51,"// MARCH-",MAR!B51,"// APRIL-",APR!B51,"// MAY-",MAY!B51,"// JUNE-",JUN!B51,"// JULY-",JUL!B51,"// AUGUST-",AUG!B51,"// SEPTEMBER-",SEP!B51)

The purpose is to combine text fields containing notes from monthly reporting spreadsheets for on a roll up report. The // are visual separations of monthly data.

However the problem is that some months have no data. So the string returned is as follows below. I would like to use an IF statement that will insert "No Comments Added" string where the concatenated cell is empty.

OCTOBER-// NOVEMBER-Continuing coordination with ABC Communities to increase installations.// DECEMBER-// JANUARY-// FEBRUARY-// MARCH-// APRIL-// MAY-// JUNE-// JULY-// AUGUST-// SEPTEMBER-Installed a sizable commercial system for ABC Communities.

Is this possible?
Thanks.

Try this:

=CONCATENATE("OCTOBER-",IF(OCT!B51<>"",OCT!B51,"No Comments Added"),"// NOVEMBER-",IF(NOV!B51<>"",NOV!B51,"No Comments Added"),"// DECEMBER-",IF(DEC!B51<>"",DEC!B51,"No Comments Added"),"// JANUARY-",IF(JAN!B51<>"",JAN!B51,"No Comments Added"),"// FEBRUARY-",IF(FEB!B51<>"",FEB!B51,"No Comments Added"),"// MARCH-",IF(MAR!B51<>"",MAR!B51,"No Comments Added"),"// APRIL-",IF(APR!B51<>"",APR!B51,"No Comments Added"),"// MAY-",IF(MAY!B51<>"",MAY!B51,"No Comments Added"),"// JUNE-",IF(JUN!B51<>"",JUN!B51,"No Comments Added"),"// JULY-",IF(JUL!B51<>"",JUL!B51,"No Comments Added"),"// AUGUST-",IF(AUG!B51<>"",AUG!B51,"No Comments Added"),"// SEPTEMBER-",IF(SEP!B51<>"",SEP!B51,"No Comments Added"))

 

[TMCINNIS]

Try this:

=CONCATENATE("OCTOBER-",IF(OCT!B51<>"",OCT!B51,"No Comments Added"),"// NOVEMBER-",IF(NOV!B51<>"",NOV!B51,"No Comments Added"),"// DECEMBER-",IF(DEC!B51<>"",DEC!B51,"No Comments Added"),"// JANUARY-",IF(JAN!B51<>"",JAN!B51,"No Comments Added"),"// FEBRUARY-",IF(FEB!B51<>"",FEB!B51,"No Comments Added"),"// MARCH-",IF(MAR!B51<>"",MAR!B51,"No Comments Added"),"// APRIL-",IF(APR!B51<>"",APR!B51,"No Comments Added"),"// MAY-",IF(MAY!B51<>"",MAY!B51,"No Comments Added"),"// JUNE-",IF(JUN!B51<>"",JUN!B51,"No Comments Added"),"// JULY-",IF(JUL!B51<>"",JUL!B51,"No Comments Added"),"// AUGUST-",IF(AUG!B51<>"",AUG!B51,"No Comments Added"),"// SEPTEMBER-",IF(SEP!B51<>"",SEP!B51,"No Comments Added"))

Thank you. Worked like a charm.

 

[Fishboy]

Thank you. Worked like a charm.

Happy to help mate