Nested IF conditions

[rajpreetsidhu]

Hi,

I have a column say col A and I want to concatenate this with other 2 columns (say B,C) columns based on below conditions and populate say column D

1) If col B is null and (col C is null OR col C = 'null' (string), then col D = A
2) If col B has an "@" AND col C is not NULL AND col C <> 'null' (string), then Col D = concatenate (A,B,C)
3) If col B does not have an "@" AND col C is not null AND Col C <> 'null' (string), then Col D = concatenate(A,C)

This seems straightforward, but I am working on this for a while and somewhere it keeps breaking. I just need pretty basic approach (nested IF's may be) to accomplish this.

Thanks in advance

 

[isabelle]

hi,

i suppose times are in the cells A1: A13
formatting cell B2 to: [h]:mm
in cell B2 enter the formula =A2-A1
and then fill down

isabelle

Le 2014-04-23 16:22, (e-mail address removed) a écrit :

 

[isabelle]

sorry, wrong way

Le 2014-04-23 22:37, isabelle a écrit :

hi,

i suppose times are in the cells A1: A13
formatting cell B2 to: [h]:mm
in cell B2 enter the formula =A2-A1
and then fill down

isabelle

Le 2014-04-23 16:22, (e-mail address removed) a écrit :

Hi,

I have a column say col A and I want to concatenate this with other 2 columns
(say B,C) columns
based on below conditions and populate say column D
1) If col B is null and (col C is null OR col C = 'null' (string), then col D = A
2) If col B has an "@" AND col C is not NULL AND col C <> 'null' (string),
then Col D = concatenate (A,B,C)
3) If col B does not have an "@" AND col C is not null AND Col C <> 'null'
(string), then Col D = concatenate(A,C)

This seems straightforward, but I am working on this for a while and somewhere
it keeps breaking.
I just need pretty basic approach (nested IF's may be) to accomplish this.
Thanks in advance

 

[rajpreetsidhu]

Thanks All. I got it resolved now.