IF THEN to change data

Question

Hi

I am trying to use an IF Then formula to change the data, however when the condition is met, rather than return the text string, it returns a "0".

Here is the formula I have written:

IF [SKU NUMBER]='126091' THEN [VINTAGE]='Y2020' ELSE [VINTAGE]ENDIF

The formula is looking at this data set:

And when it finds the SKU NUMBER 126091 instead of changing the vintage to 'Y2020' it returns a '0'

The data type for SKU NUMBER and VINTAGE are VW_String

Thank you to anyone who can help me with this.

MarqueeCrew · Accepted Answer

@KatyGuarneri ,

a formula acts on either an existing variable or a new variable. So....

IF [SKU NUMBER] = "126091" THEN "Y2020"

ELSE [VINTAGE]
ENDIF

Cheers,

Mark

MarqueeCrew · Accepted Answer

@KatyGuarneri ,

IF [SKU NUMBER] IN ("12345","12353","12361")

THEN "Y2020"

ELSE [VINTAGE]
ENDIF

cheers,

mark

p.s.  It's okay to mark this as a solution too.