String 1 = 'X' And String 2 = 'Y' Then String 3 = 'A' Else String 3

[tcwildhart]

This should be so straight forward, but not sure why my formula doesn't work. 

Table:

Type	Region	MGR	ASST MGR
Store	IL	Tom	Bill
Store	GA	Jane	Jane
Shop	IL	Tim	Sue
Store	GA	Jane	Jane
Shop	IL	Tim	Sue
Store	GA	Jane	Jane
Shop	GA	Jen	Sam

OutPut Column [MGR]

Formula:

IF [Type]="Store"
AND [Region]="GA"
THEN "Mary"
Else [MGR]
ENDIF

Desired Result: 

Type	Region	MGR	ASST MGR
Store	IL	Tom	Bill
Store	GA	Mary	Jane
Shop	IL	Tim	Sue
Store	GA	Mary	Jane
Shop	IL	Tim	Sue
Store	GA	Mary	Jane
Shop	GA	Jen	Sam

[fmvizcaino · Accepted solution]

Hi @tcwildhart ,

Attached is a solution. I only copy pasted your formula into my workflow.

Maybe you have some additional spaces in your texts you need to remove in order to work.

Best,

Fernando V.

[danilang · Accepted solution]

Hi @tcwildhart 

I'm just going off the table that you posted, but it has these issues

1. The [Type] column has a trailing space in the column name

2. One of the "Store" values has a trailing space as well.

The first one will cause an error in your formula.  The second will not match since "Store " != "Store"

Dan 

[tcwildhart]

Thanks to both of you... The good news is that I had it all right, the bad (and good) news is that I need to scrub my input before using it to calculate. Thanks!