Help with Formula Logic multiple conditions on an IF statement

(0) Share

Report

Posted on by gazzo1967

1,151

Hi Everyone

Could some on give me some direction?

I am creating a preview of a form which will be emailed (HTMLText).

I am attempting to setup that text displays based on Dropdown values.

I have done it with selecting one value but can you do it with 2 values in one IF statement

My formula currently is

&" " & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &" " & If(Dropdown1_1.Selected.Value="Minor Development", Dropdown1_1.Selected.Value)

I tried this but it doesn't work

&" " & If(Dropdown1_0.Selected.Value="Minor Development", Dropdown1_0.Selected.Value) &" " & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &" " & If(Dropdown1_1.Selected.Value="Minor Development" Or "Safety Critical", Dropdown1_1.Selected.Value)

Any help appreciated

Gary

All responses (2)

Answers (1)

v-monli-msft on at

Like (0)

Report

Re: Help with Formula Logic multiple conditions on an IF statement

Hi @gazzo1967 ,

Thanks for sharing your resolution here and hope others could benefit from it.

Regards,

Mona
Verified answer

gazzo1967 1,151 on at

Like (0)

Report

Re: Help with Formula Logic

Hi All
I have found the solution (I am new to this lol) so this is to help the other new users 🙂
Instead of using If statements you use a Switch
Switch ( the value you want to action,
"measure", outcome,
"measure2",outcome )

in my case the example would be
Switch(Dropdown1_1.Selected.Value,
"Minor Development", DataCardKey1.Text,
"Safety Critical", DataCardKey1.Text
)

Hope this helps someone 🙂
Gary