If condition for Blank Cell
 

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 condition for Blank Cell
 

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

--
__________________________________
HTH

Bob

"Maperalia" wrote in message
...
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 condition for Blank Cell
 

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Maperalia" wrote:

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 condition for Blank Cell
 

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

Kind Regards
Maperalia

"Bob Phillips" wrote:

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

--
__________________________________
HTH

Bob

"Maperalia" wrote in message
...
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 condition for Blank Cell
 

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

Kind regards

"Shane Devenshire" wrote:

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.

--
If this helps, please click the Yes button

Cheers,
Shane Devenshire


"Maperalia" wrote:

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