If condition for Blank Cell

[Maperalia]

I wonder if somebody can help me with this matter. I have the following formula

=IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"",
("( "&C22&" ) "&D22&" ( "&E22&""" ) +
( "&C23&" ) "&D23&" ( "&E23&""" ) +
( "&C24&" ) "&D24&" ( "&E24&""" ) +
( "&C25&" ) "&D25&" ( "&E25&""" ) +
( "&C26&" ) "&D26&" ( "&E26&""" ) +
( "&C27&" ) "&D27&" ( "&E27&""" ) "))

However, it is working only when the cell C22 is empty. I do not know if is
possible what I am looking for. Basically, what I need is to active
statements that have descriptions typed. For example, I typed numbers in the
cell C22, D22, E22 and C23, D23, E23 and I got the following result:

( 2 ) Full ( 23.875" ) + ( 1 ) 2 ( 4.75" ) + ( ) ( " ) + ( ) ( "
) + ( ) ( " ) + ( ) ( " )

Although the cells C24, C25, C26, and C27 do not have any information all
the parenthesis () and apostrophes†appear.

Could you please tell me how to fix it?

Thanks in Advance

Maperalia

 

[Bob Phillips]

=IF(C22=0,"","( "&C22&" ) "&D22&" ( "&E22&")")
&IF(C23=0,"","("&C23&" ) "&D23&" ( "&E23&")")
&IF(C24=0,"","("&C24&" ) "&D24&" ( "&E24&")")
&IF(C25=0,"","("&C25&" ) "&D25&" ( "&E25&")")
&IF(C26=0,"","("&C26&" ) "&D26&" ( "&E26&")")
&IF(C27=0,"","("&C27&" ) "&D27&" ( "&E27&")")

 

[Shane Devenshire]

Hi,

I think you want this:

=IF(AND(C22=0,C23=0,C24=0,C25=0,C26=0,C27=0),"",
"( "&C22&" ) "&D22&" ( "&E22&" )" &
"( "&C23&" ) "&D23&" ( "&E23& " )" &
"( "&C24&" ) "&D24&" ( "&E24&" )" &
"( "&C25&" ) "&D25&" ( "&E25&" )" &
"( "&C26&" ) "&D26&" ( "&E26&" )" &
"( "&C27&" ) "&D27&" ( "&E27&" ) ")

You can add (+) text you need to concatenate it. and you may or may not
need the """ but I took them out.

 

[Maperalia]

Bob;
Thank you very much IT IS WORKING PERFECTLY!!!!

Kind Regards
Maperalia

 

[Maperalia]

Shane;
Thanks very much. Works in the way you set it up too.

Kind regards