How do I use an if statement in a calculation field?

Hi all,

Feeling kind of dumb asking this, but I can’t get the formatting of a simple if statement correct.


Ho Josh,
the calculated field is evaluated as a javascript. So - if you want to put a condition there, you can use a pattern like:
condition ? resultForTrue : resultForFalse
I will append a picture with my test.
State == 'New' ? Age : Age * 5
I hope it helps