nested formula

[dan-74]

Hello

I am trying to create a variable to return an email address that may exist in one of three places

We have three fields for email : 'Work Email'; 'User Email'; and 'Email'. My variable should return the Work Email first.

Where there is no 'Work email', it should return the 'User email', and where there is no 'Work email' or 'User Email', it should return 'Email'.

So to clarify:

No Work Email Then User Email

No User Email Then Work Email

No User Email or Work Email Then Email

No User Email or Email Then Work Email

My current formula looks like this, but it's not quite working and I am hoping that someone is able to assist please

Many thanks in advance

Dan

[dan-74]

What I currently have:

If IsNull([Work E-Mail Address] )Then [User Email] ElseIf IsNull([Work E-Mail Address]) And IsNull([User Email]) Then[Email] Else [Work E-Mail Address]

[krisa24 · Accepted solution]

Hi,

this should do a job.

= If Not(IsNull([Work E-Mail Address])) Then [Work E-Mail Address]
ElseIf Not(IsNull([User Email])) Then [User Email] 
ElseIf Not(IsNull([Email])) Then [Email]
Else "unknown"

[dan-74 · Accepted solution]

Ah Thank you so much krisa24 !!

Perfect

Thanks for your help and apologies for not replying sooner

With regards

Dan