AnsweredAssumed Answered

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

Question asked by hanstrager on Mar 27, 2014
Latest reply on Mar 28, 2014 by 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..?

Outcomes