AnsweredAssumed Answered

Using the CASE function

Question asked by cathyhampshire1 on Apr 21, 2016
Latest reply on Apr 22, 2016 by mathepac

I am trying to get the case function to work and it does not seem to evaluate the second part of my test.  Not sure what I am doing wrong.  Here is my formula:

 

Case(Taxable = "yes" and Sale Date ≥ 04/01/2016 ; (Selling Price+DELIVERY  HANDLING - LESS TRADE) * .029; Taxable = "yes" and Sale Date <= 04/01/2016 ; (Selling Price- LESS TRADE) * .029; Taxable = "no" and Sale Date ≥ 04/01/2016 ; 0.00; Taxable = "no" and Sale Date <= 04/01/2016 ; 0.00)

 

It doesn't want to look at the Sale Date.  It is just evaluating it on Taxable.  Any suggestions?  I am not good at writing formulas.

Cathy

Outcomes