If condition for Blank Cell

  • Thread starter Thread starter Maperalia
  • Start date Start date
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?

Thanks in Advance

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