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

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.

It's giving me this result:

($.00 SIMILAR)...BBB

Am I doing something wrong?

I think I got it... thanks

Il 18/09/2012 16:28, managingcrap ha scritto:
plinius;1605618 Wrote:
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.


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)