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.
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.