If condition for Blank Cell

M

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?

Maperalia

=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&")")

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.

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

Kind Regards
Maperalia

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

Kind regards