Need help with Concatenate and If

[ananthram]

Please help me with Concatenate and if(with 2 criteria's)

=CONCATENATE([@Status],[@[Sub Status]])


the above 1 is use... now what i need is 


=if([@Status]="asd"&[@[Sub Status]]="zxc",=CONCATENATE([@Status],[@[Sub Status]]),[@Status])

i need a formula format like this.


please help me with this...Thanks in Advance.

 

[kaushik03]

Hi Ananthram,


May I request you to explain your criteria in words and give a manual output of your expected result (after concatenation)?


Kaushik

 

[ananthram]

Hi Kaushik,


what i need is a formula which includes IF and CONCATENATE, where IF should contain 2 criteria in Logical_Test & CONCATENATE should be in [Value_if_true],the 1st criteria as [Value_if_false].


=if(criteria_1="asd"&Criteria_2="zxc",concatenate(<criteria_1>,<Criteria_2&#62,<criteria_1&#62.


if Cell A has

asd and B has [code]zxc

, then C should will be calculated as asdzxc[/code],

or else vice versa.


please help me

 

[amrit1186]

Hi Ananthram


You can use the following formula,


=IF(AND(A1="asd",B1="zxc"),CONCATENATE(A1,B1),A1)


Amritansh

 

[ananthram]

you are awesome thnx amrit

 

[amrit1186]

Hi Ananthram


Your query is not clear to me.


Could you please share the spreadsheet.


Amritansh