7 Replies Latest reply on Mar 28, 2014 10:05 AM by hanstrager

    I can’t figureout how to use the Case/If statement. I have a calculation, which depends on d...

    hanstrager

      Post

           I can’t figureout how to use the Case/If statement.

           I have a calculation, which depends on different parameters. And been trying to fool around with the case statement which I can’t get working.

           I’m trying to figure out how to get the following to work:

            

           Case (Investment VAT switch = "with VAT" ; TOTAL AMOUNT;

           Investment VAT switch = "without VAT" ; TOTAL AMOUNT - (TOTAL AMOUNT / 6);

           Investment VAT switch = "without VAT" & VAT_noVAT = "noVAT" ; TOTAL AMOUNT)

            

           Can get the first 2 cases to work, but the last one is giving me the result TOTAL AMOUNT - (TOTAL AMOUNT / 6); how do I use multiply parameters..?