IF THEN to change data

[KatyGuarneri]

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 solution]

@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

[KatyGuarneri]

@MarqueeCrew Thank you SO MUCH!!  

[KatyGuarneri]

One more question....

I have about 50 different SKU NUMBERS that I would like to follow the same rule. 

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

Rather than create 50 individual if/then statements what would be a recommended formula to use?  

Thank you for any help you can provide.  

[MarqueeCrew · Accepted solution]

@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.