Conditional Formula

Conditional Formula

Hi,
This is a great application. I love it!

Is it possible to make Formula values conditional on the value of other fields?

eg

NewField
(
type = formula
if ($OldField == "Old")
{
value = "New"
}
else
{
value = "Old"
}
)

Thanks,

Lee.