for some reason this isnt working? am i doing it wrong?

If [dmvselection = "Transfer Fee"]

15

Else If [ dmvselection = "needs DMV" ]

(cashprice * .065) + 50

Else

0

End If

says Specified field cannot be found and highlights the if on the first line

are you doing this as a script or trying to do this as a calculation?

calculation

Hi Adam. Are you working on a script or a calculation? It's tough to tell from the way this is laid out. Your last comment indicates that maybe this is a calculation--if so, check to make sure you have typed "IF" and not "LF". FM is not recognizing that first word as a reserved word, so it must not be "IF". Also, Else statements cannot be used in a calculation. You'd be better off with:

Case ( dmvselection = "Transfer Fee" , 15 , dmvselection = "needs DMV" , (cashprice*.065)+50 , 0 )

Jerry

try If(dmvselection = "Transfer Fee", 15,(cashprince * .065) + 50, 0)

think this should work for you

Thank you Blue, Jerry for geting back to me fast, both your sugjestions worked great

I would be quite surprised if this worked. You have three results specified for a function that only allows two. You might be able to use nested Ifs, but this is much easier using Case anyway.