Trying to change value of a field based on the result of an if statement

[SamCrowell]

I am trying to use an if statement to change the value of the field but continue to run into errors. Will an if statement work here or if not what is the best method to do so? Thank you

IF [MoonRoof] = 1 THEN [MoonRoof_Cost] =825

ELSE [MoonRoof_Cost] = 0
ENDIF

[alexnajm]

This should work!

IF [MoonRoof] = 1 THEN 825

ELSE 0
ENDIF

[SamCrowell]

I am trying to make it so that it changes the value of a different field (MoonRoof_Cost). Is that possible to do with this formula?

Thank you

[alexnajm]

Yep, you just have to select the field where it says "Select Column" to it goes there!