Formula Help - ifThenElse looking for 2 qualifiers

[PhotoMommie]

Maximus Another fun formula question!

I have an ifThen formula that defines a color code, but I need it to include another factor:

Current working code: ifThen(finish == 'NATURAL', series = '1'; colorCode = '1');

I need it to actually reflect another variable. If the Finish = Natural AND modifierCode = null, then series = '1'; colorCode = '1', ELSE series code = '3', colorCode = '1'

How do I write this??

[PhotoMommie]

Ima dork, I figured it out:

ifThenElse(finish == 'NATURAL' && modifierCode == null, series = '1'; colorCode = '1', series = '3'; colorCode = '1');

[yuri]

I recommend to write it in the following form:

ifThenElse(
    finish == 'NATURAL && modifierCode == null,
    serias = '1'; colorCode = '1',
    series = '3'; colorCode = '1'
);

Better for reading.