|
Conditional concatenating!!!
1 Attachment(s)
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... |
Conditional concatenating!!!
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. |
Quote:
It's giving me this result: ($.00 SIMILAR)...BBB Am I doing something wrong? |
I think I got it... thanks
|
Conditional concatenating!!!
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) |
| All times are GMT +1. The time now is 04:47 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com