I see what you're trying to do and am also interested in the answer as I haven't used those commands since my class in BASIC 20 years ago
One would think it would simply be. IF C6 = NY then (F6*1.08) or whatever, but I doubt it's that obvious. Then ofcourse you need the "otherwise (F6*1).