Help with Formula Logic multiple conditions on an IF statement

[gazzo1967]

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

&"<br><br><b>" & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &"<br></b>" & If(Dropdown1_1.Selected.Value="Minor Development", Dropdown1_1.Selected.Value)

I tried this but it doesn't work

&"<br></b>" & If(Dropdown1_0.Selected.Value="Minor Development", Dropdown1_0.Selected.Value) &"<br><br><b>" & If(Dropdown1_1.Selected.Value="Minor Development", DataCardKey1.Text) &"<br></b>" & If(Dropdown1_1.Selected.Value="Minor Development" Or "Safety Critical", Dropdown1_1.Selected.Value)

Any help appreciated

Gary

[gazzo1967 · Accepted solution]

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

[v-monli-msft]

Hi @gazzo1967 ,

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

Regards,

Mona