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