Service Max Formula and IF statement

[mangeh72]

Hello.

Since there is no Else statement in service max formulas, I wounder if it some how is possible to do nestled if statements.

IE   I want to do something like this:

IF LineType  = 'Type1'  then  Price = x + y

IF LineType = Type2 then price = x-y

[susanne_klaasen]

The IF function in SFM formulas seem to work very much like an IF statement in Excel  - IF(logical_test, value_if_true, value_if_false).  This means that in the "value_if_false" section, you can add another IF statement and thus get nested IF statements.  Not very pretty, but probably do-able.