Nested IF conditions


R

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
 
Ad

Advertisements

I

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 :
 
I

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
 
Ad

Advertisements


Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top