Conditional concatenating!!!

[managingcrap]

I have this excel code:

=CONCATENATE(F149,TEXT(G149,".00")," PASSIVE, ",N149,TEXT(O149,".00"),
ACTIVE, ($",TEXT(P149,".00"),"SIMILAR)...BBB ")

F149 = A1* $
G149 = THE DOLLAR AMOUNT
N149 = A1* $
O149 = THE DOLLAR AMOUNT

The result is something like the one below:

A1* $.00 PASSIVE, A2* $0.00 ACTIVE, ($93.45SIMILAR)...BBB

by the way, the words (passive, active or similar) are not referenced t
any cell. What I am wanting to do is, everytime my A1 does not have
value, I want to make sure that the whole text (A1* $.00 PASSIVE) won'
appear. It's something like that:

If G149=no value (meaning, the cell is left blank) and O149= 5.00, th
result I want to see when I copy the cell formula from excel to wor
would be:

A2* $5.00 ACTIVE, ($93.45SIMILAR)...BBB

Now if G149=$1.75 and O149=$1.25, the result I wanna see is:

A1* $1.75 PASSIVE, A2* $1.25 ACTIVE, ($93.45SIMILAR)...BBB


I had done this before, but I can't remember the formula. Please help..

+-------------------------------------------------------------------
|Filename: Sample.jpg
|Download: http://www.excelbanter.com/attachment.php?attachmentid=590
+-------------------------------------------------------------------

 

[plinius]

Il 18/09/2012 05:54, managingcrap ha scritto:

I have this excel code:

=CONCATENATE(F149,TEXT(G149,".00")," PASSIVE, ",N149,TEXT(O149,".00"),"
ACTIVE, ($",TEXT(P149,".00"),"SIMILAR)...BBB ")

F149 = A1* $
G149 = THE DOLLAR AMOUNT
N149 = A1* $
O149 = THE DOLLAR AMOUNT

The result is something like the one below:

A1* $.00 PASSIVE, A2* $0.00 ACTIVE, ($93.45SIMILAR)...BBB

by the way, the words (passive, active or similar) are not referenced to
any cell. What I am wanting to do is, everytime my A1 does not have a
value, I want to make sure that the whole text (A1* $.00 PASSIVE) won't
appear. It's something like that:

If G149=no value (meaning, the cell is left blank) and O149= 5.00, the
result I want to see when I copy the cell formula from excel to word
would be:

A2* $5.00 ACTIVE, ($93.45SIMILAR)...BBB

Now if G149=$1.75 and O149=$1.25, the result I wanna see is:

A1* $1.75 PASSIVE, A2* $1.25 ACTIVE, ($93.45SIMILAR)...BBB


I had done this before, but I can't remember the formula. Please help...


+-------------------------------------------------------------------+
|Filename: Sample.jpg |
|Download: http://www.excelbanter.com/attachment.php?attachmentid=590|
+-------------------------------------------------------------------+

=IF(G149,F149&TEXT(G149,".00")&" PASSIVE,
","")&IF(O149,N149&TEXT(O149,".00")&" ACTIVE,
","")&"($"&TEXT(P149,".00")&" SIMILAR)...BBB"

Hi, E.

 

[managingcrap]

Il 18/09/2012 05:54, managingcrap ha scritto:-

=IF(G149,F149&TEXT(G149,".00")&" PASSIVE,
","")&IF(O149,N149&TEXT(O149,".00")&" ACTIVE,
","")&"($"&TEXT(P149,".00")&" SIMILAR)...BBB"

Hi, E.

It's giving me this result:

($.00 SIMILAR)...BBB

Am I doing something wrong

+-------------------------------------------------------------------
+-------------------------------------------------------------------

 

[plinius]

Il 18/09/2012 16:28, managingcrap ha scritto:

It's giving me this result:

($.00 SIMILAR)...BBB

Am I doing something wrong?


+-------------------------------------------------------------------+
+-------------------------------------------------------------------+

I presume that in your sheet G149=0 and O149=0 (and P149 too)